Forum Discussion
Power BI online Service slicer will return blank when multiple choices selected
I have no problem to select customer A only from slicer and the table return value for Customer A, and then I select customer B only, it return value correctly for customer B. But when I select both customer A and B from the same slicer, it return nothing . What's the issue?
thanks
Hi Bucks1327 - as i have shared the views to check, summary added here:
Check Data Model Relationships → Ensure a correct 1: relationship* between Customers and Sales.
Fix the DAX Measure → Use IN instead of ||.
Check Row-Level Security (RLS) → Remove RLS temporarily to see if it’s blocking data.
Check Slicer Settings → Ensure Single Select is OFF.
Look for Conflicting Filters → Other slicers might be filtering the table.
Re-Publish & Refresh the dataset in Power BI Service.check the above functionality and it works as per selection.
Hi Bucks1327 ,
Thank you for reaching out to the Microsoft Fabric community. We appreciate rajendraongole1 , valuable insights into your issue. Thank you, rajendraongole1 for your input. we tested the suggested scenario, and it worked well. In addition to the provided advice, please consider the following points which might help resolve your issue.
-
Check if there are any visual-level filters applied to the table that might be interfering with the slicer's output.
-
Use a different dataset or create a small sample dataset to test the slicer's behavior. This can help isolate the issue.
-
Make sure you are using the latest version of Power BI Desktop, as updates often include fixes for known issues.
We have also attached a screenshot for your reference. Please take a look.
If my answer addressed your query, please mark it as the Accepted Solution so that others can easily find the solution. I would also appreciate a 'Kudos' if you found my response helpful.
-
4 Replies
- rajendraongole1
Super User
Hi Bucks1327 - as i have shared the views to check, summary added here:
Check Data Model Relationships → Ensure a correct 1: relationship* between Customers and Sales.
Fix the DAX Measure → Use IN instead of ||.
Check Row-Level Security (RLS) → Remove RLS temporarily to see if it’s blocking data.
Check Slicer Settings → Ensure Single Select is OFF.
Look for Conflicting Filters → Other slicers might be filtering the table.
Re-Publish & Refresh the dataset in Power BI Service.check the above functionality and it works as per selection.
Thank you so much for helping
V-yubandi-msftCommunity Support
Hi Bucks1327 ,
Thank you for reaching out to the Microsoft Fabric community. We appreciate rajendraongole1 , valuable insights into your issue. Thank you, rajendraongole1 for your input. we tested the suggested scenario, and it worked well. In addition to the provided advice, please consider the following points which might help resolve your issue.
-
Check if there are any visual-level filters applied to the table that might be interfering with the slicer's output.
-
Use a different dataset or create a small sample dataset to test the slicer's behavior. This can help isolate the issue.
-
Make sure you are using the latest version of Power BI Desktop, as updates often include fixes for known issues.
We have also attached a screenshot for your reference. Please take a look.
If my answer addressed your query, please mark it as the Accepted Solution so that others can easily find the solution. I would also appreciate a 'Kudos' if you found my response helpful.
Thank you very much for helping. The issue here is solved . Customers are integers but the data types were set as characters which caused issue. After changing the customer data type to whole number, the slicer works fine to have multiple selection. Appreciate your help
-
