Forum Discussion

krishnakumar_Ra's avatar
krishnakumar_Ra
Helper I
2 years ago
Solved

Filter based Filter

I have two filters Filter_1 and Filter_2)

If  I choose Country in Filter-1 Then Filter_2 Values must contain Countries (yellow)

If  I choose City in Filter-1 Then Filter_2 Values must contain CIty (green)
IS this Feasible in PBI



Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi krishnakumar_Ra 

    Please check out the solution in the attached PBIX file


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

3 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi krishnakumar_Ra 

    What does your data look like, can you please share a screenshot or sample data?

    Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

    • krishnakumar_Ra's avatar
      krishnakumar_Ra
      Helper I
      2 years ago
      NameCountryCity
      KrishnaIndiaChennai
      PeterUSNY
      XangChinaBejing
      RamIndiaChennai
      JohnUSNY
      ChangChinaBejing
      • PijushRoy's avatar
        PijushRoy
        Community Champion
        2 years ago

        Hi krishnakumar_Ra 

        Please check out the solution in the attached PBIX file


        Let me know if that works for you


        If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

        Thanks
        Pijush
        Linkedin