Forum Discussion
parameter constrained by another parameter
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?
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")
1 Reply
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")