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 Experts
How would you show the total Sales by each product type..
So
Product | Region | Sales |
Apples | North | 10 |
Apples | South | 10 |
Apples | East | 5 |
Apples | West | 2 |
Apples Total | 27 |
Solved! Go to Solution.
Use a matrix visual. It has lots of controls for displaying totals.
If you insist on using a table visual then you need to duplicate your data table, rename all Regions to "Total" and then union it back with the original table. Be prepared to explain the display to your confused users.
Use a matrix visual. It has lots of controls for displaying totals.
If you insist on using a table visual then you need to duplicate your data table, rename all Regions to "Total" and then union it back with the original table. Be prepared to explain the display to your confused users.
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 |
---|---|
105 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |