cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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 Team
Community Support Team

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
New Member

Re: how to create multiple filter visuals which filters reports

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 Team
Community Support Team

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

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
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors