Forum Discussion
Filtering with two parameters
Hi Anonymous ,
I have create a simple example. The original data table is as follows. And I set parameter_depart=A /B/C and parameter_user=1/2/3.In my table, it doesn’t satisfy the two parameters.
I'm in this situation because my dataset does not satisfy both parameters. There is no row in table B after filtered by parameter_depart and parameter_user.
After I changed the data, it works well.
So please make sure the data satisfy the two parameters at the same time.
I have found a similar post, please refer to the following topic to see if it helps you.
https://community.powerbi.com/t5/Desktop/Cascading-selection-filters/m-p/260894
Or there is an document about cascading dropdowns, if it is the desired output you want.
https://forum.enterprisedna.co/t/power-bi-cascading-dropdowns/21859/2
If it doesn’t help, please provide your simplified pbix without privacy information and desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous thanks for your help. The problem is that the data and the parameters are correspondent, but there are certain combinations of parameters that result in empty tables. For example, you filled in B and 1 as parameters, but there is no combination of B with 1 in your data, which I believe would still result in an empty table in your solution. What I need is that if you get a list of parameters A/B/C and you choose one, and then you have to choose from 1/2/3, it first filters the table with the first parameter, and then only the options for the second parameter remain that you can still choose from.