Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 a...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    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!

     

     

lkalawski's avatar
lkalawski
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hi JanikSchaefer,

 

Please add a picture using the post editor.



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