parameter constrained by another parameter

[hgrangeret]

Hi,

I would like to define dependencies between my parameters, eg a product category and sub category:

Say I have a product table, once I have selected a product category, I would like that the list of sub categories are filtered on the category value selected in the category parameter.

Is it feasible?

[PattemManohar · Accepted solution]

@hgrangeret Create a list in "Power Query" for the list of distinct values of subcategory and with the filter criteria to filter by the parameter value of "Product Category" (which is a parameter). You can use this new list as parameter value for "Sub Category" (By using "Suggested Values" as "Query")