Parameter filter parameter

[fosterXO]

Hi,

I am familiar with parameters using different dimensions. I usually create parameters with 2 or 3 fields. I set that parameter on a graph or table so users can select the field /dimension / formula they need.

I need to create a parameter that allow me to filter other parameter.

 E.g. I have measures calculated in USD, EUR and GBP: revenueusd, revenueeur, revenuegbp and profitusd, profiteur and profitgbp. I have a table with these 6 columns. Now the users can select in a revenueparameter and in a profitparamater their preferred currency. The new parameter will allow me to select the currency and only the 2 correct columns will be displayed. One selection instead of two. (In the real case would be +15 selections).

[v-jianboli-msft · Accepted solution]

Hi @fosterXO ,

Based on your description, I have created a simple sample:

Please try:

First create a field parameter:

Then add two columns to the table 'Parameter':

Create two slicers with the two columns:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.