Hierarchical filters for parameter values

[DivyaReddy]

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:

[v-yadongf-msft]

Hi @DivyaReddy ,

Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.

Best regards,

Yadong Fang

[v-yadongf-msft · Accepted solution]

Hi @DivyaReddy ,

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.

[amitchandak]

@DivyaReddy , I would advice using bookmarks and buttons in this case

Bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks