Forum Discussion

Advocate V

6 years ago

Solved

Dynamic column header in Matrix

Hello friends, I need my matrix columns to show months' names according to the slicer value chosen. I understand that it is not yet supported and I have voted for an idea on this. But I am still l...

Need Help

v-gizhi-msft
6 years ago
Hi,

After my test, I think if you do not have column headers, you can not dynamically change measure headings.
And also custom visuals can not reach this.

Best Regards,
Giotto Zhi

v-gizhi-msft

Community Support

6 years ago

Hi,

If your data is like my test table as below, i have a workaround:

Please create a column to show Year and Month:

Year&Month = FORMAT('Table'[Date],"YYYY-MMM")

Then create a calculated table, choose its column as a slicer:

Slicer = SELECTCOLUMNS('Table',"Date",[Date],"Name",[Year&Month])

Then create a measure to show the chosen month's data and previous one month's data:

Value in Matrix = 
IF (
    SELECTEDVALUE('Table'[Date]) <= MAX('Slicer'[Date]) && SELECTEDVALUE('Table'[Date])  >= DATE(YEAR(MAX('Slicer'[Date])),MONTH(MAX('Slicer'[Date]))-1,1),
    SUM ( 'Table'[Sales] ),
    BLANK ()
)

The result shows: