Forum Discussion

AnetaK's avatar
AnetaK
Helper V
3 years ago

Dynamic (very!) column headers in matrix

Hello,

I have an issue with column headers in matrix.

I need to show 12 months - dynamicly changed.

That is not a big issue - I can use a month name from the calendar as a column.

But there are two more requirements:

1. I have to add some other measures to the matrix,

2. These 12 month have to be dynamically changed by the slicer - so if I select September, then I want to see Sep and 11 prevoius months, if I select May, then May would be the first one and then 11 previous months.

 

 

What I did (as the only solution I found) - I created separate measures for each column and added additional cards with dynamic headers to cover the matrix headers.

It worked when I didn't touch the matrix.

 

But I can go up and down the 4-level hierarchy - and then the allignment is not working anymore.

 

I should have dynamic headers as a regular part of the matrix.

 

Any idea what can be done?

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    AnetaK , Create slicer on an independent date table, then you can have measure like

     


    //Date1 is independent Date table, Date is joined with Table
    new measure =
    var _max = maxx(allselected(Date1),Date1[Date])
    var _min = eomonth(_max, -12) +1
    return
    calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

     

     

    Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

  • AnetaK's avatar
    AnetaK
    Helper V
    3 years ago

    I already have two separate calendar tables, measure is not an issue.

    Issue is how to change column names.