Forum Discussion
Parameter filter parameter
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).
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.
1 Reply
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.