Log In
Register
Home
July 11, 2017
Offline
Hi
I'm trying to make an Interactive Dashboard but am stuck with the Chart & Slicer options:
Can the graph size automatically change to fit the info in it so bar sizes always remain the same width, e.g. see Group 1 compared to group 11 or group 3?
Can the slicer auto update to only show the related groups to the sites that are actively showing in the Pivot Table?
I have a Value filter on the Pivot table to only show sites with a value of less than -10%, is there a way to give the user an option to change this value themselves on the dashboard between -10% & -5% without going to the Pivot table?
Any help would be greatly appreciated.
Thanks
Paul
July 16, 2010
Offline
Hi Paul,
The overall size of the chart will not adjust so that the bars/column remain the same width. This is by design because often a chart will form part of a larger report and you wouldn't want all charts adjusting in size every time a different filter was applied.
There is a setting in the Slicer where you can choose not to show items with no data. Right-click the Slicer > Settings.
Note: your file didn't upload because there is a percentage sign in the file name. It's a good idea to avoid using special characters in file names.
Mynda
1 Guest(s)
