Forum Discussion
How to create sub column header in this case?
This is the original table in power query above. This is what I want it to look like in my report (the highlighted part). I used EXCEL only to demonstrate what I wanted in Power BI r...
amitchandak
Super User
Super Usercatpoisoncat , In the matrix Office and Month, need to row, then you think about header grouping, using calculation group or unpivot
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
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0