March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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 Products | 120 |
Product 1 | 3 |
Product 2 | 5 |
Product 3 | 7 |
Product 4 | 9 |
Product 5 | 30 |
Product 6 | 10 |
Product 7 | 30 |
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
.
Solved! Go to 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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |