Dynamically change Measure Title based on slicer

[Akakaboto]

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?

[mlsx4]

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

[Akakaboto]

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.