Forum Discussion

Dimitris_Kats's avatar
Dimitris_Kats
Icon for Helper V rankHelper V
2 years ago

Dynamic measure name

[ Spoiler ] Hello dear members.  I need your help. I have created the following measure: Calculate(sum('table'[value]), selectedvalue( 'Version'[version]= 'table'[version])) This measure is dyna...
"DAX help"
dynamic column names
Dimitris_Kats's avatar
Dimitris_Kats
Icon for Helper V rankHelper V
2 years ago

Hi. Thank you very much for your reply.

As I mentioned I have used the following measure in matrix

Selected Version 1= Calculate(sum('table'[value]), selectedvalue( 'Version1'[version1]= 'table'[version]))

In the matrix the column name displayed is the Selected Version 1

I want that name to change dynamically based on the slicer selection. So if the user has selected from the slicers "Actual" then I want as column name "Actual" 

I hope this makes sense now 😃 

Alex87's avatar
Alex87
Icon for Solution Sage rankSolution Sage
2 years ago

Thank you! It is clear now!  🙂

From what I know, as of today, there is no possibility to change the name of the column created in the matrix. The hack I am usually doing is that I replace the name of the measure in the visual with an empty character (instead of Selected Version 1) (Empty Characters, Whitespaces & Blank Unicode Characters) and I overlay on the matrix an empty button where I control through fx the text to be displayed. (do not forget to activate maintain layer order on).

Does it answer your query?

  • Dimitris_Kats's avatar
    Dimitris_Kats
    Icon for Helper V rankHelper V
    2 years ago

    Hi. Thank you so much for your help.

    This is what I am currently using but I have been asked to create several more tables with monthly analysis so on and I was hoping to find a better, quicker and more viable solution 🙈

    Thank you so much again for you help.