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!

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.