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 slicer. Below is my Tier table
| Q FY | SUM | tier 1 | tier 2 | tier 3 |
| Q4-20 | ||||
| Q1-21 | 379330 | 398296.5 | 407779.8 | 417263 |
| Q2-21 | 535134 | 561890.7 | 575269.1 | 588647.4 |
| Q3-21 | 582095 | 611199.8 | 625752.1 | 640304.5 |
| Q4-21 | 539333 | 566299.7 | 579783 | 593266.3 |
| Q1-22 | 606106 | 636411.3 | 651564 | 666716.6 |
| Q2-22 | 677126 | 710982.3 | 727910.5 | 744838.6 |
| Q3-23 | 955667.5 | 1003451 | 1027343 | 1051234 |
The BHDH Measure is summing 6 colums
I would like for the card to display the BHDH selected fiscal and quarter and show what Tier it is
As an example IF FY22 Q1 value is less than 636411.3 then display "below Tier 1", between 636411.3 and below 651564 Display "Tier 1", between 651564 and below 666716.6 display "Tier 2", everything above 666716.6 display "Tier 3"
This would be dynamic based on the FY and quarter selected
All my tables are joined to a Fiscal Calendar
Thank you
2 Replies
- amitchandak
Super User
Aahubs , 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
