Forum Discussion
Helper VDynamic measure name
Solution SageI do not understand what it the problem you want to solve. What column name? used where? can you provide more examples, ideally print screens of what you have and what are your expectations? thanks
Helper VHi. 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
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
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.