All Year text in Textbox

Hello Everyone,
 
Anyone can help me regarding the below requirement:
There is requirement
  1. When I have not selected any slicer value then in the Text box Number that is "All Year".
  2. When I have selected any slicer value then in Text box display '2019'(Year Number)

Thanks

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟤
    Accepted Answer

    If you make a beastmode that just has SUM('yourcolumn') and put that in the text value, it should sum up the values for you when no filter is selected.Otherwise, the textbox card is set to just grab the first value in the dataset.

This discussion has been closed.