powerbi

breakdown measure on pie chart for Power BI - data managing issue


I have a set of data and I create a table like this:

Table

Data looks like that: enter image description here

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


Solution

  • 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!

    https://community.fabric.microsoft.com/t5/Desktop/breakdown-measure-on-pie-chart-for-Power-BI-data-managing-issue/td-p/4422136#M1375217