Forum Discussion
Group Column Headers When Data Cannot be Unpivoted
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.
2 Replies
- amitchandak
Super User
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/456795Thanks 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.
