I have a set of data and I create a table like this:
I am trying to make a pie chart.
As you can see, each column "selling obj" is independent measure.
When creating a pie chart since this columns are independent it does not breakdown by selling object, I need to add all of them as value and I cannot sort them.
I am looking for a way to have a breakdown by selling object so I can sort them.
Your help is appreciated. Thanks
Thanks to the Microsoft fabric community, I found the proper way to do:
To make "Selling Object" a single category (instead of multiple columns), we need to unpivot the data.
First open your Power Query: Select the table containing selling obj 1, selling obj 2, and selling obj 3.
Then Highlight the columns selling obj 1, selling obj 2, and selling obj 3.
Next rename Columns
Then just create your pie chart!