July 11, 2017
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.
July 16, 2010
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.