Forum Discussion
Dynamic Classification from Companys
Hi,
I want to make a dynamic classification where the User can select step sizes of a classification and the number of classes.
This is the situation:
| Company | Sales |
| A | 10 |
| B | 50 |
| C | 80 |
| D | 100 |
If the user select step size 50, there should be 2 classes with: 0-50 (class 1) and 51-100 (class 2). In the classes the sales should be added, so class 1 has a sum of 60 and class 2 a sum of 180
If he selects step size 20, there should be 5 classes. (class 1: 0-20, ..., class 5: 81-100
The number of classes depends on the maximum of the sales amount and we should watch for rounding.
I thought of connecting another table who has just the step sizes from 1:1000 and the user can select a number he wants to see.
Is there any possible way to do this?
Thanks in advantage. I have an example pbi, where I made a manuell classification with;
Hi Anonymous
This article seems to be just what you need:
https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-binsIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
- Ritaf1983
Super User
Hi Anonymous
This article seems to be just what you need:
https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-binsIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly