Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |