Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Slicing data across multiple columns

I have lots of data that can be summarized into the following type of data (this is not my data but it a smaller version and sanitised). From the data I want to have a stacked column chart sho...
Need Help
Hariharan_R's avatar
Hariharan_R
Solution Sage
4 years ago

Hi Anonymous 

You need to unpivot your columns into rows to acheive the results easily. You can do this in Power Query layer or DAX. Please refer below. Once you unpivoted then you can easily build a visuals.

 

Power Query - https://kohera.be/power-bi/how-to-unpivot-twice/

DAX - https://community.powerbi.com/t5/Desktop/Convert-multiple-column-data-into-a-column-with-multiple-rows/m-p/674345

 

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin


  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Superb Hariharan_R  ! Just what was required.  Thank you very much for your help, much appreciated.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Superb Anonymous R ! Thank you very much that is exactly what I needed to do!