Custom numeric Bin Range as a slicer filter

[Anonymous]

Hello everyone,

I am trying to build a slicer filter with a custom bin range

Currently I am using the combination of shapes and bookmark to arrive to this filtering,

but I want to filter the data based of a measure filter, that could work with normal or some custom slicer.

This is what I have arrived to, but there are fundamental issues with this, it wont work with any slicer.

filter KMS 0-150 = CALCULATE(VALUES('Prototype Modeling_Freight'[KMs]), AND('Prototype Modeling_Freight'[KMs]>=0,'Prototype Modeling_Freight'[KMs]<=150))

The range I am trying to filter is:

Any comments or suggestions are most welcome.

thanks in advance

[v-diye-msft · Accepted solution]

Hi @Anonymous 

It's not accessible in power bi, the measure is not working in slicer, bookmark would be the best solution to achieve your requirement.

[amitchandak]

@Anonymous , refer if this can help

https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization