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 🥷
    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.

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
This discussion has been closed.