Forum Discussion

kumarleau's avatar
kumarleau
Frequent Visitor
8 years ago

Cascading selection filters

Hi

 

I need a help from you. I just started working on power bi.

I wnat to achieve a kind of cascading filters.

I have two fields called Region and country.

If I select any value from Region then automatically I should able to see only that corresponding Region countries.

I have searched it, but I couldn't find the solution. Please help me.

 

Regards,

Kumar

Need Help

3 Replies

  • miltenburger's avatar
    miltenburger
    Helper V
    8 years ago

    Hi kumarleau

     

    If your database is in such good shape, it should happen automatticaly.

    For instance, if i select yaer 2017, it automatticaly shows me the dates from this year in another filter.

     

    So put 2 filters on yuor report. First 1: Region, 

    2nd: Country, 

    Then select a region, and the other filter should automatically change

     

    Kind regards

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi kumarleau,

     

    You can also try the custom visual Hierarchy Slicer.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

     

     

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi kumarleau,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

    Best Regards!
    Dale