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 give the user another slicer / filter option to choose the specific ‘customers’ in my example. Interactively selecting the customers is not an option since the list of customers is huge.

Thank you very much in advance!

Sample workbook screen shot. So here the user should be able to chose the 'Parameter-Slicer' and then the specific customer from the list of customers and the report should have those values. 

 

 

My dataset:

 

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.

     

     

     

3 Replies