Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Hierarchical filters for parameter values

Hi PBI community! I created a simple parameter (in my example ‘Parameter’) and have a slicer for it. It works great! But what I need is, based on the parameter value chosen by the user, I need to gi...
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi Anonymous ,

     

    This is my test table:

     

    Transform in the Power Query:

     

    You will get a table like this:

     

    You will get result you want:

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.