Forum Discussion
Give Columns Shared Header
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
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,
KellyDid I answer your question? Mark my post as a solution!
6 Replies
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,
KellyDid I answer your question? Mark my post as a solution!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
Hi JanikSchaefer,
Please add a picture using the post editor.
_______________
If I helped, please accept the solution and give kudos! 😀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
refer if this can help
