Dynamic Measure Names (Titles) using Field Parameters - #PowerBI

This video covers one of the use case with field parameters. I am showing you how you can change the measure names dynamically.

Subscribe my channel for videos

[pahadianalyst]

This is the most elegant solution to the problem. Thank you so

[ashokkumarpadmanabhan]

Excellent Video !!! Appreciated your effort of making video and sharing. Keep sharing more videos. I Learned new things today :)

[abdoulmoz]

Thank you that was simple, Helpful and Informative. I would give you a hundred thumbs up if i could

[rauljimenez]

I agree with @pahadianalyst, this is by far the most elegant and simple solution I have seen for this issue!! Thank you very much for sharing!

[LauriLaitinen]

Ingenious and very helpful. Thank You!!!

[AnnaKoeman]

Great! This fixes a problem that we have had for a long time in one of our reports

[harkpun]

Thank you Hari... I was exactly looking for this solution where I am stuck in my current project.

[nithinp]

Excellent
I am serching for this
Thanks

[Ethan-ddln]

Excellent video! Can you dynamically change them with a different field parameter value? I can’t seem to figure out how to reference a field parameter in custom columns

[hardeepcharak]

Thanks Anna. That was useful, how we can bring Text from another selected field and not the date.

[carlosgomez-dfcg]

Hi Great video, thank you!.

can it be modified to work with a slicer where i can select a specific month?. i am developing a PBI where the user can select a month and the report must show the last months of sales.

[BigDataSport]

Is it possible instead of using for column title names, a slicer and change "column title names" based on slicer value, instead of today ? I tried using a measure but failed, doesn't get refreshed.
I need dynamic columns ( first column of the field parameters table with names, changing with a slicer selection, first column of this table using a measure")
Regards

[leofang]

Hi Hari, Thank you for doing this. I wonder if I apply this method with a Year_Quarter column on the matrix, does
this method still work?

[VoiceOfSpeed]

Hey Hari,

I am trying to do something similar to what you are showing in this video, but for whatever reasons its not working, can you take a look please

Dynamic Header = {
Year])), " ") & " Sales", NAMEOF('Key Measures'[DB - Sel Year Target]), 0),
("DB - Sel Year Touchpoints", NAMEOF('Key Measures'[DB - Sel Year Touchpoints]), 1),
("DB - Comp Year Target", NAMEOF('Key Measures'[DB - Comp Year Target]), 2),
("DB - Comp Year Touchpoints", NAMEOF('Key Measures'[DB - Comp Year Touchpoints]), 3)

Above is code and i am trying to dynamically show the year selected on the slicer, and it only shows the hardcoded word "Sales" for me

[rheiniousragland]

Need to create a new measure as database name which should be dynamic

[LisaRobbins-dg]

Can you tell mw why when I try to do this, exactly they way you do, Power BI keeps crashing when I try to add the Dynamic Column to the Table. It asks me to report the 'Something Went Wrong' warning.

[stephencross]

Is this solution still working in the newer versions of PowerBi? I can't seem to find the field parametres

[peterlin]

Hi Hari, great video. In my report, I have user select a Slicer (ie: 2023-01, as in YYYY-MM), how do I use that in field parameters? I couldn't get it to work.

[aliyanrazzaq]

Can we name headers based on user selected year from slicer?

[saibharathi]

Hi Hari, thanks alot for the video
But I want to change name in such a way that whatever month I select from my date slicer it should show previous month name and before previous month name of that selected month
Please reply