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

[HB13]

Hi all

I 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;

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) ? 

Many thanks and kind regards

[v-luwang-msft]

Hi @HB13 ,

Set up Attribute (you can rename it) as your column in the matrix visual, and the Values column as your matrix's Values. 

And you could learn about 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/... 

Best Regards

Lucien

[amitchandak]

@HB13 , Based on what I got, Calculation group should help, refer few format I have discussed here

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