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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
rampsaladi
Frequent Visitor

All Other Products in Pie Chart

Hi All,

 

I have requirements where I need to create a Pie Chart with a certain set of products and All other products as one group. The Products and sales information are in the same table and I also have another Product called ALl products along with the Sales. as shown below

 

Product$ Amt
All Products120
Product 13
Product 25
Product 37
Product 49
Product 530
Product 610
Product 730

 

I need to get All Other Products by Subtractinig from ALl products sum of Products 1to 7 and then include this as part of the Pie chart as shown below. Any Help on this would be appreciated

Pie Chart.PNG

1 ACCEPTED SOLUTION

Hi @rampsaladi

 

May be you can use the Query Editor to add a row for "ALL other products"

 

- You can pivot the Products Column>> all your products would be in columns

-Then add a column "All other products" subtracting Products 1 to 7 from ALL products

-Now unpivot the products to bring data to orginal form

 

View solution in original post

3 REPLIES 3
Zubair_Muhammad
Community Champion
Community Champion

HI @rampsaladi

 

How about a new calculated table which you can use in the pie chart...From the modelling tab>>>New Table

 

Table =
UNION (
    FILTER (
        SUMMARIZE ( TableName, TableName[Product], "$ Amt", SUM ( TableName[$ Amt] ) ),
        [Product] <> "All Products"
    ),
    ROW (
        "Product", "All other Products",
        "$ Amt", CALCULATE ( SUM ( TableName[$ Amt] ), TableName[Product] = "All Products" )
            - CALCULATE ( SUM ( TableName[$ Amt] ), TableName[Product] <> "All Products" )
    )
)

 

@Zubair_Muhammad Thanks for the reply

 

I have thought of it but it gets more complicated as the data I showed will be associated to a specific market and time period. I would need to be able to do this for different markets and time periods. If that can be achieved that would be great and you can provide me details on how to 

Hi @rampsaladi

 

May be you can use the Query Editor to add a row for "ALL other products"

 

- You can pivot the Products Column>> all your products would be in columns

-Then add a column "All other products" subtracting Products 1 to 7 from ALL products

-Now unpivot the products to bring data to orginal form

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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