Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
AnetaK
Helper V
Helper V

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.

 

AnetaK_0-1671179452607.png

 

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.

AnetaK_1-1671179759776.png

 

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

AnetaK_3-1671179928174.png

 

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

 

Any idea what can be done?

 

2 REPLIES 2
AnetaK
Helper V
Helper V

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

Issue is how to change column names.

amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.