Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I would like matrix column names to change in relation to current month.
If current Month is November I would like column headings to be
Account November October September
ABC001 100 120 90
If current month is December headings to be
Account December November October
ABC001 100 120 90
To show figures for current and previous two months. I can produce the figures I don't know how to make column headers dynamic.
Rather than have to retype them when the date changes to a new month.
The account and figures are just for information and do not affect the column heading.
Is it possible to change matrix column heading using a formula or some other way?
Thank you in advance
Pete
Solved! Go to Solution.
In a Matrix, put Month Name in Columns, then add a date slicer and limit to the last 3 months.
@PBE Thanks for the Kudos! Can you please accept as solution if this has solved the issue?
Hi @PBE ,
Please enable field parameters in preview features:
This is my test table:
Create tewo measures:
Nov = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Month] = "Sep" || 'Table'[Month] = "Oct" || 'Table'[Month] = "Nov"))
Dec = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Month] = "Dec" || 'Table'[Month] = "Oct" || 'Table'[Month] = "Nov"))
Select "Fields" in Modeling tab:
Add two measure just created.
You will get a parameter table like this:
Create a slicer using parameter just created and create a matrix as below shown:
Then you can Dynamic Matrix Column Month Header:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @PBE ,
Please enable field parameters in preview features:
This is my test table:
Create tewo measures:
Nov = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Month] = "Sep" || 'Table'[Month] = "Oct" || 'Table'[Month] = "Nov"))
Dec = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Month] = "Dec" || 'Table'[Month] = "Oct" || 'Table'[Month] = "Nov"))
Select "Fields" in Modeling tab:
Add two measure just created.
You will get a parameter table like this:
Create a slicer using parameter just created and create a matrix as below shown:
Then you can Dynamic Matrix Column Month Header:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@PBE Thanks for the Kudos! Can you please accept as solution if this has solved the issue?
In a Matrix, put Month Name in Columns, then add a date slicer and limit to the last 3 months.
Hi @PBE ,
Can you please show your data model as well as the measure you use so far, please?
Best regards
Michael
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |