How to create a PBI table visual with grouped-column and sub-column names

Question

Hi allI am trying to create a table visual in PBI whereby columns comparing data from this year, last year and the year-on-year change are grouped under a broader column heading. Like this;&nbsp;&nbsp;Group and Branch are coming from an imported table, all other fields (ThisYear, LastYear and YOY change) are measures. How do I go about grouping the measures under their relevant headings (Gross Amount, Quotes etc) ?&nbsp;&nbsp;Many thanks and kind regards

amitchandak · Answer

HB13 , Based on what I got, Calculation group should help, refer few format I have discussed here 
&nbsp;
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

v-luwang-msft · Answer

Hi&nbsp;HB13&nbsp;,
Set up Attribute (you can rename it) as your column in the matrix visual, and the Values column as your matrix's Values.&nbsp;
&nbsp;
And you could learn about&nbsp;unpivot in power bi.
Similar question refer:
https://community.powerbi.com/t5/Desktop/How-to-display-measure-as-sub-columns-in-matrix-visual/m-p/749323&nbsp;
&nbsp;
&nbsp;
Best Regards
Lucien

Forum Discussion

How to create a PBI table visual with grouped-column and sub-column names

2 Replies

Related content

Create columns group

Sort by column within sub groups

Grouping rows by Column and then updating Column

Grouping Columns

Deneb Vega Lite Sub Columns?