I don't think you can control it as a quick filter, since Measure Names works by having all measures available.
I attached an example workbook that I think delivers what you are asking.
1. Create a graph of just Sales
2. Create a graph of just Profit
3. Use your existing graph of Sales + Profit (I added Measure Names to color to separate the sales and profit lines)
4. Create a dashboard with all sheets included in the same container. You must hide the title on all sheets for the hide/show to work properly
5. Create a parameter and put on dashboard to allow user to select Sales, Profit, or Both
6. Create a calculated field (Choose Graph) with the parameter so you can use it as a filter
7. On the sales sheet, add Choose Graph as a filter and select only the Sales value
8. On the profit sheet, add Choose Graph as a filter and select only the Profit value (easiest way is to change the parameter value on your dashboard from Sales to Profit before you add the filter so the value appears)
9. On the sales + profit sheet, add Choose Graph as a filter and select only the Sales + Profit value (easiest way is to change the parameter value on your dashboard from Profit to Sales + Profit before you add the filter so the value appears)
10. Create a title sheet where the sheet title is the parameter value and put that on the dashboard, so you can have the title change dynamically based on parameter selection
Once that is done, the correct graph should show on the dashboard and the others should be hidden.
measure name v2.twbx 1.2 MB
Thanks for your reply. But I cannot open you workbook. Could you downgrade to V10.3?
It is a good alternative to use parameter if we have very few measure names. However, If we have 5 measure names, and want to show any 2, 3 or 4 of them, then it will be very difficult. We have 10+ possibilities to show any 2 of them, 6+ possibilities to show any 3 of them, 4+ possibilities to show any 4 of them. It's impossible to list all of these possibilities in the parameter.
Any ideas to resolve this?
Agreed. If you don't need to use the measures in other places in the data set, you could hide the measures, which should remove them from the list. See attached where I've hidden three of the measures but then selected to show hidden measures in the list so you can see how they are disabled, and not shown in the quick filter.