Thanks for having a look Peter Fakan!
I had a look at your twbx and saw that you added the following calc:
if [MED_AVDEDU]==[Full Cube] then [MED_AVDEDU]
else [Full Cube]
This does provide part of the functionality that I want, which is to "back-fill" in values where MED_AVDEDU doesn't exist (in my workbook I use an LOD to accomplish something similar).
However, the other wrinkle is that I need to be able to switch out MED_AVDEDU for other measures. This would be trivial if I could use a parameter, but unfortunately I cannot use parameters because of the following 2 requirements that parameters can't fulfil:
- I need a single select dropdown menu that allows find-as-you-type to narrow the dropdown (currently only available for quickfilters, not parameter dropdowns)
- In my production dashboard, I have category filter dropdown that further helps to narrow the choices. In the production dashboard there are something like 100 different choices, so being able to narrow the selection is key.
What you are asking is far too complex to achieve without using the full functionality of Tableau. By limiting your choices to quickfilters only, you are limiting the solution. Does your organisation also use Word but not allowed to change the font or font size ?
My initial thoughts on your most recent post is there is a slim chance this might work (depending on your data and what you are doing with it) if you replace your quick filters functionality with selectable sheets - the idea behind this is looking at narrowing the choices as your key functionality. I've mocked up a quick example using superstore data to show you what I mean. I didn't have time to find an example in the data where the filter will 'change' based on the first selection, but this will work in practice (i.e. if 'Home Office' was selected but there were no 'Standard Class' items, then the 'Standard Class' option would disappear).
HTH 18.3 attached
844809.twbx 2.4 MB