Forum Discussion
Matrix Overarching Header
Hello,
I am trying to create sections in my matrix view but cannot find a way to make it dynamic. If I create text boxes above the sections it obviously won't adapt if a filter is applied or the drill-down feature is used.
This is how I want it to look. Is there a way to get the words "P&L Details", " FY23 Selected Periods", and "FY23 Whole Year" to be used as column headers for a section?
Thank you,
Kristina
KristinaH , refer if these can help
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/456795or Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
1 Reply
- amitchandak
Super User
KristinaH , refer if these can help
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/456795or Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0