Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help - Dynamically Change Total to Average from CARD visual

Hi guys, I need your help on below exercise:   I have here a card which has a Total Price YTD of $2.9M. I want to dynamically change that to AVERAGE instead of TOTAL using a slicer. Is that possibl...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Sorry for the confusion. I need to have a button that will automatically change the computation inside the Total Price YTD CARD FROM SUM TO AVERAGE using the formula above. 

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      5 years ago

      Anonymous ,  Both option I suggested should work

      Bookmark can work with buttons and measure slicer with horizontal Orientation should work

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks! It worked! Thank you for the new learning.