I have a scenario of using two slicers to filter data, below are the steps:
1. Create two slicers with same column (Which is easy)
2. Filter the visual based on both selections (This is returning empty data)
Can someone suggest how to achieve this?
Is there any specific reason you want to use two slicers from the same column to filter data? If you want to use separate slicer to filter separate visual, you can edit interactions between visuals follow this: Create Complex Interactions Between Visualizations, or use Visual level filter instead.
Yes @v-qiuyu-msft, My reports has a page of Brands comparision side by side with multiple charts (for which I have edited Interactions), but in same page I have 2 charts which shows comparision in one visual (Multiline trends & Grouped barchart).
Firstly in a slicer visual, we can't control how many values can be selected by end users. You can consider create a new table which only have a table column contains two values, then use this column in the slicer visual, create a relationship with original table as well.
Another good option is that you can use Visual level filter as I suggested optionally. After you save the report and publish to service, user view report by change different filters won't affect other user's results.
Why would you want two slicers on the same column? Wouldn't it be easier for users to just select several (such as two) values in the same slicer?
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.