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.
I have this basic data set:
Name | Category | Totals |
Todd | Category A | 7500 |
Brian | Category B | 5000 |
Stewart | Category B | 4000 |
Todd | Category A | 3000 |
Chelsea | Category A | 1500 |
Vanessa | Category B | 700 |
Steven | Category B | 400 |
Elliot | Category A | 250 |
On Page 1, I'm doing a breakdown of everything that happened with Category A, and the same on Page 2 with Category B. I'm doing the same table for each breakdown and am doing the Top 3 values for each category, so on Page 1, I'd want this:
Category A Table:
Name | Value |
Todd | 7500 |
Stewart | 4000 |
Chelsea | 1500 |
And this on Page 2:
Category B Table:
Name | Value |
Brian | 5000 |
Todd | 3000 |
Vanessa | 700 |
Currently, when I do this on the separate pages, it's not showing the Top 3 based on the filters (Page 1 is filtered completely for Category A, Page 2 filtered completely for Category B). It's essentially showing only the top values until it gets to the other category, where it stops counting. Is there a way I can create a measure or a calculated column (preferred) that would allow me to correctly do the tables?
Solved! Go to Solution.
Found the solution! It was as simple taking the Value column and, clicking on the down carrot, change the default "Sum" checkmark and change it to "Don't Summarize." It was grouping all similarly valued items together instead of displaying them separately.
Found the solution! It was as simple taking the Value column and, clicking on the down carrot, change the default "Sum" checkmark and change it to "Don't Summarize." It was grouping all similarly valued items together instead of displaying them separately.
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |