Forum Discussion
Dynamically change Measure Title based on slicer
In above table I have a column with Estimate
Estimate =
VAR _Scenario = SELECTEDVALUE ( dimScenario[Scenario] )
RETURN
CALCULATE (
[CurrencyPeriodic],
ALL ( Scenario ),
Scenario[Scenario 02] = _Scenario
)
Based on which Scenario is selected in my slicer (currently E3, E5, E9 E11) it of course shows the Estimate for that Scenario. (I prefer to do it this way instead of creating a measure for each scenario and then use an additional switch measure to toggle between them as it greatly reduce the number of measures in my report).
What I would like to know is if I could dynamically change the column name to display Est E3, Est 5, Est 9 or Est 11 based on the slicer selection instead of just Estimate? Any Suggestions?
2 Replies
Hi Akakaboto
Maybe this link is helpful for you: https://community.fabric.microsoft.com/t5/Desktop/Create-a-dynamic-measure-column-name/m-p/961419
thanks for your reply. I am not sure that will work for me but I will think about it. Noticed there are quite many similar questions on this forum, someone of those threads should have the answer I need.
