Forum Discussion
Post ProdigyPower BI slicer with "between" function bug
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.
Impactful IndividualYes, 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.