Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Thanks,
Nikhil
I have the same scenario. Need two date slicers based on the same column. Help us!
Hi @Anonymous,
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.
Best Regards,
Qiuyun Yu
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).
Hi @Anonymous,
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.
Best Regards,
Qiuyun Yu
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?
Thanks @erik_tarnvik, Yes your suggestion is the best option to have but can I restrict user to select only two selections in slicer?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
97 | |
93 | |
87 | |
68 |
User | Count |
---|---|
173 | |
134 | |
132 | |
102 | |
95 |