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 a table with a column and values. I'm trying to group the values into group ranges. For exmple
Amounts |
10000 |
5000 |
4000 |
2000 |
5 |
11000 |
12000 |
20000 |
15000 |
30000 |
100000 |
25000 |
80000 |
18000 |
21000 |
14000 |
23500 |
and im looking for an outcome like this.
Amounts | Count |
Between 1 and 10000 | 5 |
Between 10001 and 20000 | 6 |
Between 20001 and 30000 | 4 |
Above 30000 | 2 |
Solved! Go to Solution.
Hi @atari35
Probably the easiest is to create add a calculated column with the range:
Bucket = SWITCH ( TRUE (), Table1[Amount] <= 10000, "Between 1 and 10000", Table1[Amount] <= 20000, "Between 10001 and 20000", Table1[Amount] <= 30000, "Between 20001 and 30000", "Above 30000" )
then use it in a matrix visual with a simple COUNT measure
Hi @atari35
Probably the easiest is to create add a calculated column with the range:
Bucket = SWITCH ( TRUE (), Table1[Amount] <= 10000, "Between 1 and 10000", Table1[Amount] <= 20000, "Between 10001 and 20000", Table1[Amount] <= 30000, "Between 20001 and 30000", "Above 30000" )
then use it in a matrix visual with a simple COUNT measure
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 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |