Change the column name of a matrix depending on a filter selection

user_9517769 0
Viewed 564

I have the following matrix (I simplified it) :

enter image description here

I want when I select the months for the 2020 year, the name of the column Year becomes Year 2020 so that column is dynamically modified depending on the year selection.

and the next column will be Year N-1 which is Year 2019. How can I achieve that ?

dax powerbi
1 Answers

What you are asking here is whether it is possible for dax to dynamically change the measure name based on the slicer selection?

The answer is no. In the current capacity, it is not possible to dynamically change the measure name. MeasureName MeasureName=sum(fact[sales]) is defined by the user.

user_111561310
Related