Forum Discussion
Slicer multiple choices return nothing
I can select customer A only and return report correctly and select customer B only and return reporting correctly. But when I select both customer A and B from the same slicer, it return nothing. It's PowerBI service.
what's the issue here?
thanks
Hi Bucks1327 - If selecting Customer A and Customer B separately works fine but selecting both at the same time returns nothing, the issue is likely related to filter context, relationships, or DAX logic.
In Model View, check if there's a many-to-many relationship that might be preventing multiple selections.
Ensure that your customer filter properly applies to the fact table.Eg :,
CALCULATE(
SUM(Sales[Revenue]),
Customers[CustomerName] IN {"A", "B"}
)Click on the slicer, go to Format pane → Selection controls, and turn off "Single Select".Coming to RLS, you can
Go to Manage Roles and check if the security filter is too restrictive.Reset filters by clicking "Clear All Filters".Check "Edit Interactions" in the report.
Hope this helps.
1 Reply
- rajendraongole1
Super User
Hi Bucks1327 - If selecting Customer A and Customer B separately works fine but selecting both at the same time returns nothing, the issue is likely related to filter context, relationships, or DAX logic.
In Model View, check if there's a many-to-many relationship that might be preventing multiple selections.
Ensure that your customer filter properly applies to the fact table.Eg :,
CALCULATE(
SUM(Sales[Revenue]),
Customers[CustomerName] IN {"A", "B"}
)Click on the slicer, go to Format pane → Selection controls, and turn off "Single Select".Coming to RLS, you can
Go to Manage Roles and check if the security filter is too restrictive.Reset filters by clicking "Clear All Filters".Check "Edit Interactions" in the report.
Hope this helps.