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!

     

     

v-kelly-msft's avatar
v-kelly-msft
Community Support
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!

 

 

theexcel's avatar
theexcel
New Member
1 year ago

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