Give Columns Shared Header

[Anonymous]

Hey Guys,

I am trying to visualize Data (mainly text) in a big table, and give certain variables (columns) a shared header.

So for example if I have colums 1-7 in a table, I want to have 1,2 and 3 to have the common header "financials", 4 and 5 to have the header "Project Details" and 6 and 7 to have the shared header "status"

Is this possible in Power BI?

tried to visualize it:

Thanks guys!

Cheers,

Janik

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

First go to query editor>select all columns >unpivot columns:

Then create a calcuated column:

Column = IF('Table'[Attribute] in {"column 1","column 2","column 3"},"financials",IF('Table'[Attribute] in {"column 4","column 5"},"Project Details","status"))

Finally, create a matrix and you will see:

For the related .pbix file,pls click here.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[theexcel]

interesting solution, do you have any idea if I am using some measures and columns in a table view, how can I do the same.

best regards

Mo

[amitchandak]

You have created a new table where you to unpivot your columns /measures to rows and then add a calculated column to put them into group.  

For columns you can refer :https://radacad.com/pivot-and-unpivot-with-power-bi

[Anonymous]

Not sure if you understood my question correctly:
My data already is in colums, I just want to visualize the colums better by having a shared column header.

Hope I did not understand your answer incorrectly.

[amitchandak]

refer if this can help

https://www.daxpatterns.com/dynamic-segmentation/

[lkalawski]

Hi JanikSchaefer,

Please add a picture using the post editor.

_______________
If I helped, please accept the solution and give kudos! 😀