Reply
gvg
Post Prodigy
Post Prodigy

Power BI slicer with "between" function bug

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}.

1 ACCEPTED SOLUTION
jaweher899
Impactful Individual
Impactful Individual

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.

View solution in original post

1 REPLY 1
jaweher899
Impactful Individual
Impactful Individual

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)