Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Anonymous
Not applicable

Two slicers from one column

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  

6 REPLIES 6
vaibhavnajan
New Member

I have the same scenario. Need two date slicers based on the same column. Help us!

v-qiuyu-msft
Community Support
Community Support

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

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
erik_tarnvik
Solution Specialist
Solution Specialist

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?

Anonymous
Not applicable

Thanks @erik_tarnvik, Yes your suggestion is the best option to have but can I restrict user to select only two selections in slicer?

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.