cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Amardeep100115 Post Patron
Post Patron

how to create multiple filter visuals which filters reports

Hi

 

I wish to create multiple filter visuals from master table's multiple columen, which sync and filter report by each option and also when once visual has selected any value then other filter also work and filter the report.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: how to create multiple filter visuals which filters reports

Hi @Amardeep100115 

 

It's doable. If the slicer data is related to other visuals data, it will filter smoothly using AND condition between these slicers.

 

If you'd like to use OR conditions between these slicers, please refer to https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/

 

Here's official document probably provide more reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

 

Please let me know more detailed expected performance if it still didn't meet your requirements.

 

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

5 REPLIES 5
Super User IV
Super User IV

Re: how to create multiple filter visuals which filters reports

Hi @Amardeep100115 ,

 

That sounds reasonable.  Just drop them on the dashboard and it should work.  If it does not, please give us pictures and more info.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




AdetayoKolade
New Member

Re: how to create multiple filter visuals which filters reports

Amardeep100115 Post Patron
Post Patron

Re: how to create multiple filter visuals which filters reports

Hi 

 

Please find the attached image, in which green highleghted visual is filtering the other visuals, but i wish to other visuals also filter the visuals respective when they selected (highleghted in red).

 

FilterJPG.JPG

Community Support
Community Support

Re: how to create multiple filter visuals which filters reports

Hi @Amardeep100115 

 

It's doable. If the slicer data is related to other visuals data, it will filter smoothly using AND condition between these slicers.

 

If you'd like to use OR conditions between these slicers, please refer to https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/

 

Here's official document probably provide more reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

 

Please let me know more detailed expected performance if it still didn't meet your requirements.

 

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Highlighted
Amardeep100115 Post Patron
Post Patron

Re: how to create multiple filter visuals which filters reports

 

Please see the below data source and i wish to use sclier to filter data 

 

 

 

https://1drv.ms/u/s!Ai3rGPgy20kLwiBy0mSRyEbK5mFf?e=nvm7yH

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors