Forum Discussion

saranyasaran's avatar
saranyasaran
Regular Visitor
9 years ago
Solved

Connectivity between Filters

i am creating a filter which will be linked to another filter. Eg : i created 2 filters say Country and Region. so if i click on Country filter, the region filter should change accordingly based on the country filter selection. How is this possible in Power BI desktop? Any idea?

  • i am creating a filter which will be linked to another filter.

    Eg : i created 2 filters say Country and Region. so if i click on Country filter, the region filter should change accordingly based on the country filter selection. How is this possible in Power BI desktop? Any idea?

  • Hi  saranyasaran,

     

    I suppose you have a single table with country / region when you add the filters/slicers to your report they are interacting with each other if you want them to act individually you need to change the option in the Edit Interactions:

     

     

    I have place this in slicers but the same thing happens in the filters on the visual/page/report level, however if you don't have a connection between the two columns first of all you need to add a relationship or make a table with a link between the two columns you want to use as a connect filters and then use the solution above.

     

    Regards,

    MFelix

2 Replies

  • i am creating a filter which will be linked to another filter.

    Eg : i created 2 filters say Country and Region. so if i click on Country filter, the region filter should change accordingly based on the country filter selection. How is this possible in Power BI desktop? Any idea?

  • Hi  saranyasaran,

     

    I suppose you have a single table with country / region when you add the filters/slicers to your report they are interacting with each other if you want them to act individually you need to change the option in the Edit Interactions:

     

     

    I have place this in slicers but the same thing happens in the filters on the visual/page/report level, however if you don't have a connection between the two columns first of all you need to add a relationship or make a table with a link between the two columns you want to use as a connect filters and then use the solution above.

     

    Regards,

    MFelix