I have a chart where the user can select their metric from all the available metric columns. I used a parameter called "Metric" to build this chart. However, I have now been asked to filter the metric columns available based on the values in a couple of other columns, specifically Country and Requirement, as specified in the first tab in the Excel file attached, "criteria". So, if the user picks Country = UK and Requirement = Employment, then as explained on the criteria tab, they should ONLY be able to select four metrics for the chart: CTR, CPM, Percent and CPC. If they instead pick Country = Italy and Requirement = Sales, they should ONLY be able to pick from two metrics: Sales and Cost Per Sale. I just can't figure it out and would be very grateful for any ideas. I also have access to Alteryx if that's any help. Thank you in advance for your brains, creativity and generosity.
Hello @Tonia Perretta,
You can't filter a parameter list base on what a user has selected, but you could use a relationship, connecting your permissions to your data:
Then, creating pseudo [Measure Names] and [Measure Values] fields, you can use the [Metric] as a Dimension filter, instead of a parameter. The downside is, you're now displaying only one Measure in your worksheet, so to get different number formatting for each Metric, you'll have to convert everything to a string, which may cause you other problems. You're currently using a parameter, which only allows one value at a time. With this method, the list of allowable Metrics will be displayed, and the user can display which of them they want - you could always change the filter to a single selection if you want. I've started you off in the attached workbook. If you think it will work for your scenario, then you can continue to add other fields.
