Forum Discussion
Dynamic Title card measure based on row data
Hi Everyone, Im trying to figure out how to have a dynamic card title that will display what "Tier" the value that is being displayed in the card is based on the selected fiscal year and quarter...
amitchandak
Super User
Super UserAahubs , You can create a measure like this and use in card
Switch(True(),
[BHDH SUM Measure] < 636411.3 , "below Tier 1" ,
[BHDH SUM Measure] < 651564 , "Display "Tier 1" ,
[BHDH SUM Measure] < 666716.6, "Tier 2" ,"Tier 3"
)
amitchandak Thank you for your help! is there a way I can have something like what you have provided but depending on the quarter slicer that is selected will determine what Tier would be displayed. Each Tier has different parameters for each quarter and fiscal
This solution although will help will only give results for those set parameters, I’m looking for something that is more dynamic based off the slicer selection if possible
Any ideas will be greatly appreciated
Thank you