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,
I have the following problem,
I need to group all the categories of the waterfall chart that are not in the 90% of the total value,
for example, I have the following data
Column 1 | Column 2 |
A | 10 |
A | 12 |
B | 15 |
C | 9 |
B | 8 |
B | 5 |
A | 4 |
C | 10 |
D | 2 |
E | 1 |
F | 1 |
G | 3 |
H | 1 |
The 90% of the Total (81) is 72.9, so only B, A and C should show as individual categories and G, D, E, F and H should show like "Other". Like this
Is there any way to do this without messing with de data?
Solved! Go to Solution.
Hi rodfernandez
I would approach this with a calculated column to identify if the category in column 1 of that record should be displayed as Other or the current category. so
Plot Type = if(calculate(sum(Table1[Column 2]),filter(Table1,Table1[Column 1] = earlier(Table1[Column 1]))) > sum(Table1[Column 2])*.1,[Column 1],"Other")
Then use Plot Type as the category for your waterfall chart.
Hi rodfernandez
I would approach this with a calculated column to identify if the category in column 1 of that record should be displayed as Other or the current category. so
Plot Type = if(calculate(sum(Table1[Column 2]),filter(Table1,Table1[Column 1] = earlier(Table1[Column 1]))) > sum(Table1[Column 2])*.1,[Column 1],"Other")
Then use Plot Type as the category for your waterfall chart.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |