Forum Discussion
Dynamic Column Name based on Slicer Selection
Hi Team,
I have a measure named "Sell-Out" and Year column.
My requirement is to change the column name based on the slicer selection, here the slicer is year column.
Example : When i select 2018 in the Year slicer, my Sell-Out column should change as "Sell-Out 2018".
Similarly when i select 2017 in the year slicer , it should dynamically change the column name as "Sell-Out 2017".
Can anyone help me how to write DAX to change the column name dynamically ?
Thanks
Try adding the following calculated column and drag it to Columns of a Matrix visual.
Column = "Sell-Out " & Table1[Year]
6 Replies
there is no way to rename column dynamically based on a slicer
where do you want to display that name? you can create a measure that would return "Sell-Out 2018" based on slicer, you can then use it in card to show in dashboard@ncbshiva, https://community.powerbi.com/t5/user/viewprofilepage/user-id/11389, https://community.powerbi.com/t5/user/viewprofilepage/user-id/10823
Did you find any solution for changing column name only dynamically with the slicer selection? If You have can you please help me out
