Forum Discussion
Data Visualisation with table and a single-select slicer
Use the filter pane as it is intended to be used ("filter on all pages") or use synchronized slicers on the affected pages.
Thanks for the reply.
I have synchronised slicers to select project names for the "details" pages (there are two of them) and the filters aren't "interactive" enough as I also need to get the table to show the list of items filtered by a date slicer, which is in turn synced with the other two pages.
The original idea was to have a list of projects in a table, slicer with dates when submissions were made, tree maps to visualise status updates. Selection on a tree map then filters the table, table selection filters the tree maps.
The second part of the report is the update details where two slicers let users view updates based on project name (same as the table in the first screen) and date (synced slicer that matches selection in the first screen).
The users are asking for a way to select a record in the table and then view the details without having to change the slicer on the detail pages.
The map above should make a bit more sense of all of this. It doesn't have to drive the slicer (I can hide it and add a button to show it if someone wants to change the project manually). Any ideas are welcome.
Thanks
David