Forum Discussion
AlanP514
Post Patron
Post PatronDynamic Salary Bin
Hai, I have a challenge I want to create a Salary bin based on the latest salary, I have 2 two tabless consisting of monthly salary data and the other one is revised salary data. so I want to creat...
amitchandak
Super User
Super UserAlanP514 , If you want based on a column, Then you can create a new column.
Example
Switch(True() ,
[Salary] <10000, " Below 10K",
[Salary] <20000, "10K - 20K",
// Add others
)
If you need create a separate table with salary and bin
In case you need it on measure
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k