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.