Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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).

goofy_0-1655591961124.png

From the data I want to have a stacked column chart showing a sum of all jumpers sold and all jumpers returned across a specific time period.

Along with the above data, I have created a date table using the calendarauto function.

 

My real data has multiple 'Jumper' manufacturers and significant number of weeks data.

 

I want to only have one chart that sums all the sold and returned jumpers across a specific time period, but to then be able to 'click' a slicer for 'ABC Jumpers' and the chart to only show the values of sold and returned jumpers for 'ABC Jumpers'.  And to be able to do that for any number of 'Jumper Manufacturers'

 

Any help with how to do this would be appreciated.

 

Thanks

 

 

 

1 ACCEPTED SOLUTION
Hariharan_R
Solution Sage
Solution Sage

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


View solution in original post

3 REPLIES 3
Hariharan_R
Solution Sage
Solution Sage

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
Not applicable

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

Anonymous
Not applicable

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.