Forum Discussion
Impactful IndividualMatrix dynamic column header with YEAR and MONTH
Hello,
I read some article about dynamic colums for matrix but couldnt find an appropriate way.
I have a matrix with 20 measures. And a YEAR and MONTH slicer. What I want is:
BEFORE:
Measures in the value field / the column name:
SALES YTD CY = CALCULATE...
SALES YTD CM = CALCULATE...
...
AFTER:
SALES YTD 2020 = CALCULATE...
SALES YTD 12 = CALCULATE...
...
Is that possible?
Pikachu-Power
It is not possible to dynamically change the column name based on the slicer, my suggestion is just change the rename the column to best explain the situation, e.g. YTD(current/selected).In case you need measure help, you can use ISFILTERED function to show current and selected YTD value.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Pikachu-Power , The information you have provided is not making the problem clear to me. Can you please explain with an example.
are you looking for measure slicer ?
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://www.youtube.com/watch?v=vlnx7QUVYME
Appreciate your Kudos.
Pikachu-PowerI want that the column headers changes dynamic when i choose YEAR and MONTH.
Pikachu-Power
It is not possible to dynamically change the column name based on the slicer, my suggestion is just change the rename the column to best explain the situation, e.g. YTD(current/selected).In case you need measure help, you can use ISFILTERED function to show current and selected YTD value.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
