Forum Discussion
Change columns in Array
Hello friends I have a situation I have a report with a matrix in which it shows sales information per year, all good with the information but they ask me to make a change that I have not been able to find and so that they understand me better attached an image of how the Power BI Desktop shows me
and what they ask me is that it be shown as follows, this is in an excel
I hope you can help me with this issue.
Thanking you for your help
Best regards
Syndicate_Admin , do you want measure on top ?
You can try calculation group
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
or refer
column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795
1 Reply
Syndicate_Admin , do you want measure on top ?
You can try calculation group
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
or refer
column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795