Hi all.
I have 2 dashboards. For the first dashboard, i wanted the filter to be presented in relative date as shown below
and another dashboard to be presented in range
However, when i change either one of the dashboards,another will change accordingly.
For example, Dashboard 1 in date range and Dashboard 2 will also in date range.
May I know how to solve it?
Jun 12, 2018 7:28 PM
Hi, Haan
You can dulplicate the [Trx Date], and use one for 1st dashboard, and another one for 2nd dashboard.
ZZ
Hi Haan,
You can click the drop down caret on the filter, then select Apply to Worksheets > Selected Worksheets. Do this for each filter on each dashboard and select only the sheets that you want each filter to work on.
HTH
Peter
Dear ZZ
I have just tried this method...
But i noticed that there is a problem inherited, which is both of the filters are dependent each other. For example, one of the filter Trx Date, I select "June", then another filter I can only choose the range/date in June. If I choose other days let say May , there is no effect on the filter.
Thanks
Jun 12, 2018 7:49 PM
Hi, Haan
Are you using the same view in different dashboards? otherwise it can't.
Can you share sample workbook to show your case?
ZZ
Dear ZZ
Ya...I am...
As u can see..At the trx date copy, I choose only month for February and at the Trx Date there..i did not include February...There is no chart shown.
Thanks
Jun 12, 2018 8:07 PM
I think in this case, I will suggest to duplicate the view as well. one for 1st dashboard, and another one for 2nd dashboard.
ZZ
Jun 12, 2018 8:08 PM
Workbook attached for your reference.
ZZ
Dear ZZ
You mean duplicate the sheet? or the measure and dimensions used?
Thanks
Duplicate the sheet, then the filters can be independent.
Peter
Jun 12, 2018 8:24 PM
Please find the attachment in the original thread of my previous reply
ZZ
Dear Pekan and Zhouyi Zhang
I got it already. Thank you very much both of you
