Stacked headers in a PowerBI Table

[gordtulloch]

This seems to be a common thing but none of my searches are bearing fruit - I have a table of values with repeating sets of three columns (term 1, term 2, term 3) that need to be grouped under a stacked header so it looks like this:

+-----------------------------------+----

|                     Reading                   |

+-----------------------------------+----

|     T1        |         T2       |      T3     |

+-----------------------------------+-----

Is there a function in PowerBI to do this? In Excel I'd just create a merged cell from three cells. Any help would be appreciated thanks!

Regards,
   Gord

[parry2k]

@gordtulloch matrix visual will do it, add your group in columns and value in the values section.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Syndicate_Admin]

I'm sorry I don't follow you - grouping is just static text, so how can I put that in the columns section?

[gordtulloch]

Sorry I don't follow you - the grouping is just static text so how do I put that in the columns section?

[parry2k]

@gordtulloch share sample data to understand what you are trying to achieve. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[gordtulloch]

Here's some sample data:

First Name        Last Name                ELAT1                   ELAT2            ELAT3

Jane                  Doe                              1                           2                     3

Sally                  Student                        3                           3                     3

Output I want is:

                                                        ELA Mark

First Name        Last Name          T1      T2     T3

Jane                  Doe                      1        2       3

Sally                  Student                3        3       3

[v-yiruan-msft · Accepted solution]

Hi @gordtulloch ,

Please check if the custom visual Table Sorter is applicable for your scenario.

Best Regards

Rena

[parry2k]

@gordtulloch your data need transformation to make it work, the solution is attached, heavy lifting is done in power query to transform the data. You can take it from here and tweak it as per your model.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!