Forum Discussion

Anonymous's avatar
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...
Need Help
  • v-gizhi-msft's avatar
    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

sathishramuk33's avatar
sathishramuk33
Frequent Visitor
5 years ago

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