Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I have sets of columns that need to be grouped with a column group header. I understand this can only happen in a Matrix, NOT a Table.
Is there any way to simply apply a column header label without unpivoting the data? The data consists of several different data types (strings, currency format, percentage format, etc) and those types needs to be preserved. My actual data has about 40 columns, but I've made a dummy matrix that would be in the ideal format below.
@pivotunpivot , calculation groups can help: Calculation Groups - Use Measure with small multiple : https://www.youtube.com/watch?v=LEn6ZnScMZc
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
Thanks for the reply, but this doesn't seem to solve it. My values are all pulled from a data source. None are derived or calculated as seems to be the case in your examples. The values have varying data types.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.