- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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}.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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.
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.
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.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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.
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.
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.
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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 10-03-2023 09:30 AM | ||
Anonymous
| 07-22-2024 06:08 AM | ||
03-22-2024 03:49 AM | |||
12-14-2023 09:51 AM | |||
04-21-2024 08:19 PM |
User | Count |
---|---|
141 | |
111 | |
81 | |
61 | |
46 |