Power BI slicer with "between" function bug

[gvg]

Hello,

It looks like there is a bug in Power BI slicer. If I use it for the table {1,2,3,4,5}, that holds integer numbers only and set "between" action, I can not select values from 2 to 4 exactly, for example. If I move both sliders in an attempt to get values between 2 and 4 it sets values from 2.3453452 (or something) to 4.879823 (or something). I.e. it is not possible to set values for precise filter {2,3,4}.

[jaweher899 · Accepted solution]

Yes, you are correct. This is a known issue with the Power BI slicer and it can be frustrating for users who need to apply filters with exact values. However, there are a few workarounds you can try to resolve this issue:

1. Use a drop-down filter: Instead of using a slicer, you can use a drop-down filter to select the exact values you want to filter on. This allows you to select values from a pre-defined list, rather than having to adjust sliders to get the exact values.

2. Use a measure: You can create a measure that returns a filtered set of data based on a specific range of values. For example, you could create a measure that returns the count of values between 2 and 4. Then, you can use this measure in a visual to display the filtered data.

3. Use the Advanced filtering option: In Power BI Desktop, you can use the advanced filtering option to apply filters based on specific values. To do this, right-click on a visual, select "Filter" and then "Advanced filtering". Here, you can specify the exact values you want to filter on.

4. Create a calculated column: You can create a calculated column that returns a value based on a specific range of values. For example, you could create a calculated column that returns "Yes" for values between 2 and 4, and "No" for all other values. Then, you can use this column as a filter in your visual.

I hope these workarounds will help you resolve the issue with the Power BI slicer. If you need further assistance, please let me know.