Grouping / binning in a measure

[LamSar]

Good afternoon, 

I need help with grouping/binning.

I have this slicer: 

The values are between 0 and 53
 Is there any way that I can group the values using a measure?
I only want these values: 0,1,2,3, > 3
 So all values between 4 and 53 have to be under >3
I am using a tabular model, so grouping and binning is not possible. It is also not possible to add a calculated column

Any ideas?

[LamSar · Accepted solution]

Hello,

Thank you for your answer. 

I can't add a conditional column via Power Query, because I'm using a tabular model (live connection).

[mahenkj2]

Hello @LamSar ,

I believe a measure in a slicer would not be possible, the reason is measure is calulated at run time.

I think, two ways possible. One is to add such additional column in source table itself. This is simple to implement, if you have control over source.

Second is to create a dimension table containing these numbers and relate with the fact table. Use dimension table's column in slicer. This dimension table can be created in power bi locally, no need to convert anything at source.

Hope it helps.

[LamSar]

Ok. Thank you for your message!

[mahenkj2]

I think you need a slicer with values 0,1,2,3 and >3. To achieve this, you can add a condition column in power query. Use this column in the slicer instead and you should be able to achieve your desired effect.

I attach a sample file. I have assumed that it is not compulsarily needed a measure in this slicer.

https://drive.google.com/file/d/15619QRVqYoNfgQHXH2-vq6M5ITUQMWgh/view?usp=sharing