Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |