Dynamic column header in matrix visual (based on date filter)

[Anonymous]

Hi, 

I have 6 measures like:

measure1 = calculate(sum(data[value]), filter(calendar, format(eomonth(today(), 1), "YYYYMM") = calendar[month]))

measure2 = calculate(sum(data[value]), filter(calendar, format(eomonth(today(), 2), "YYYYMM") = calendar[month]))

Is it possible to make dynamic column headers in matrix visual (measure1 is March this month, but April next month)? 

I understand I can create, for instance, dynamic cards above the matrix, but I'd like to avoid that.

I could also create a pivoted table for these 6 months (though not sure how to make column headers and values dynamic there either), but adding another table with such complexity seems too much. 

Please advise. Thanks. 

[sathishramuk33]

hi , i have same this type of requirments now so can you got any solutions in this scenario(dynamic header change)

[v-gizhi-msft · Accepted solution]

Hi,

You can try this column:

Column = Data[Date].[Month]

Then apply relative date filter to the matrix visual:

Hope this helps.

Best Regards,

Giotto Zhi

[amitchandak]

Refer: if these can help

https://www.youtube.com/watch?v=yEemVBiaTuk

https://community.powerbi.com/t5/Desktop/Dynamic-column-name-from-its-value/td-p/189442

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

[Anonymous]

Hey, i have the same issue i didn't find any solution. I think dynamic columns titles is not available for now