Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a matrix visual showing costs for 2 specific months that are selected from a slicer. The measures used to do this are called Month1 and Month2. Is there a way I can get the column headers to change to the 2 specific months selected?
Matrix visual & slicer:
So in the above Scenario - I would want Month1 to show as Mar24 and Month2 to show as Jan24
The DAX for Month1 =
Solved! Go to Solution.
Hi all,
I eventually found my own workaround. I moved the Month1 and Month2 measures to 'Columns' in the matrix - rather than values (see image below)...
This then meant that I had 'Cost' , 'Diff' and '%' showing under each of the 2 months. I then had to hide the 'Diff' and '%' columns for every month that could be chosen in the slicer - since it is only the Total Diff & % that makes any sense. Final result works...
Thanks @Ritaf1983 for the suggestions, although I was unable to replicate any of those workarounds to my model.
Hi all,
I eventually found my own workaround. I moved the Month1 and Month2 measures to 'Columns' in the matrix - rather than values (see image below)...
This then meant that I had 'Cost' , 'Diff' and '%' showing under each of the 2 months. I then had to hide the 'Diff' and '%' columns for every month that could be chosen in the slicer - since it is only the Total Diff & % that makes any sense. Final result works...
Thanks @Ritaf1983 for the suggestions, although I was unable to replicate any of those workarounds to my model.
Hi @gaznez
We don't have this option as a core formatting.
But there are some workarounds to achieve it .
Please refer to the linked videos:
https://www.youtube.com/watch?v=zbKNyFu2BOo
https://www.youtube.com/watch?v=IM4DaT6oF6k
https://www.youtube.com/watch?v=4emPkBiiCtg
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |