Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

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(cale...

v-gizhi-msft
6 years ago
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

Icon for Super User rank

Super User

6 years ago

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