Search code examples
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.

    • Click Transform → Unpivot Columns. Power BI will now create two new columns: "Attribute" (which stores "selling obj 1", "selling obj 2", etc.). "Value" (which stores the corresponding values).

    Next rename Columns

    • Rename "Attribute" → "Selling Object".
    • Rename "Value" → "Sales Amount".

    Then just create your pie chart!

    • Drag "Selling Object" into Legend.
    • Drag "Sales Amount" into Values.
    • Now, the pie chart will group sales by Selling Object.

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