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.
Anyone know how to create custom sized groups to group values in PowerBI?
Preferably using another table that contains the ranges, so its easy to modify if needed.
Bins are not useful for this.
For example grouping days between expected delivery date and actual delivery, which ranges from values -1000 to +1000
Less than -100
-100 to -50
-49 to -20
-19 to -5
-4
-3
-2
-1
0
1
2
3
4
5-19
20-49
50-100
100+
Solved! Go to Solution.
If you want another table to be able to change it over there, than check out this:
https://www.daxpatterns.com/static-segmentation/
You can also write the segmentation in a claculated column in the table itself, but, as oppose to the above method, in this case, only the model authour could change the logic of the segmentation, where in the above method, you could potentially put this segmentation table in a database and connect to it in direct query.
P.S. Don't think you need it for this case, but also take a look on the dax pattern for dynamic segmantation:
daxpatterns.com/dynamic-segmentation/
If you want another table to be able to change it over there, than check out this:
https://www.daxpatterns.com/static-segmentation/
You can also write the segmentation in a claculated column in the table itself, but, as oppose to the above method, in this case, only the model authour could change the logic of the segmentation, where in the above method, you could potentially put this segmentation table in a database and connect to it in direct query.
P.S. Don't think you need it for this case, but also take a look on the dax pattern for dynamic segmantation:
daxpatterns.com/dynamic-segmentation/
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |