Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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?
I already have two separate calendar tables, measure is not an issue.
Issue is how to change column names.
@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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
56 | |
56 | |
38 | |
29 |
User | Count |
---|---|
75 | |
62 | |
45 | |
40 | |
40 |