Matrix Overarching Header

[KristinaH]

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

[amitchandak · Accepted solution]

@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/456795

or Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0