Forum Discussion
Power BI online Service slicer will return blank when multiple choices selected
- 1 year ago
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.
- 1 year ago
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.
-
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