Forum Discussion
Solved
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 ...
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")
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")