I have a workbook with 3 dashboards. The first has bars showing data for each month of the year. The second has a text table showing data by facility and the third has a text table showing data by patient. Right now I have it set so that the user starts on dashboard 1 and can click on any of the months. this will take them to dashboard 2 and will filter the month based off of their selection. then from this 2nd dashboard the user can click any of the facilities and that will take them to dashboard 3 once again filtered to whichever facility they chose. the issue is that i want a month filter on dashboard 2. if i use an action filter and that filter is adjusted after navigating to dashboard 2, it will not persist into filter 3. if i use a regular filter on dashboard 2 it would work, but initially when the user navigates to dashboard 2 after selecting a month in dashboard 1, it does not update to sync with that action. any advice?
Yes, this is what Im getting as well, but I would want the filter to show the correct month/year instead of all because it is a bit confusing otherwise; also I would prefer for there to be the option to change to any month/year in the 3rd dashboard, not just the month selected. How could I get this to happen?
