Hello,
in my dashboard I am having a group of slicers:
University | Faculty | Study program | Form | Degree
They are working in kind of getting from general statistics to more specific.
When users select an university from the list, then they are shown statistics for that specific university. Then in dropdown slicer Faculty they can choose one from only those faculties which are part of that chosen university and all the graphs shown are recalculated to show statistics for that specific faculty. The same works for all the remaining slicers. If no value in filter is selected, it shows All data.
My problem is, that when user has selected University A, Faculty AA and study program AAA and then decides to change selection to university B, the graphs are shown empty. I understand this is because there is no Faculty AA and study program AAA for university B. But it is not very user friendly as the user has to manually deselect value in Faculty to see values of University B.
What would I like to do is to have all the slicers automatically set to default value All after changing the selection in one of "more general" slicers.
Is it possible to set it somehow? I know I can use button with the bookmark to Reset all filters, but is there any way to do it automatically? Hopefully there is any trick or workaround. Thanks!
