Forum Discussion
Dynamic column header in matrix visual (based on date filter)
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.
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
4 Replies
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 LinkedinHi,
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
hi , i have same this type of requirments now so can you got any solutions in this scenario(dynamic header change)
