Dynamic Salary Bin

[AlanP514]

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 create a salary bin based on the latest salary. please give instructions and tips

[v-zhangti]

Hi, @AlanP514 

Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@AlanP514 , 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/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k