how to create multiple filter visuals which filters reports

[Amardeep100115]

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.

[Anonymous]

Check this link https://www.dataport.com.ng/2019/09/29/creating-a-slicer-that-filters-multiple-columns-in-power-bi/

[Amardeep100115]

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).

[v-diye-msft · Accepted solution]

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.

[Amardeep100115]

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

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

[Nathaniel_C]

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