I don't see why you couldn't build a calculation that looks at the value of both parameters
This is true, thanks Alex, but the end user wants to see a restricted list of filter values, based on user selection, for example
Filter 1 : Region (top level of hierarchy) - contains 5 regions.
FIlter 2: Sub-Region (next level of hierarchy, each with multiple values for each Region).
The end user wants, when they select a region, to only see subregions in the subregion filter which apply to the selected Region. Otherwise there could be a mismatch of region/subregion, the dashboard returns no data, and the end user is confused,
2 of 2 people found this helpful
Dave, if you use filters you can set the 'sub-filter' to show 'Only Relevant Values' and you'll get what you're looking for. You're still not going to completely solve the dashboard going blank and confusing the user problem, but at least they won't be able to make a selection in the sub-filter that would make this happen.
Thanks Shawn, i think the problem is that, on the dashboard, the "filters" are parameters, and with these you cannot set "Show Relevant Values" . Apologies for my poor terminology, i am new to dashboards.
Yes, that is one of the drawbacks of using parameters. You best option is to change them to filters. Another option is to drive them using dashboard actions. Good luck.