BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Sam Lowrie on 09 June 2018
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Creating Dynamic Charts
You can use bookmarks to manage as many charts on a page as you like, changing which ones you can see at any one time:
The problem is that things get messy really fast. Which chart was meant to be visible on bookmark 12?!
What would be smoother is to have just one chart - the same one - used by every bookmark:
Much smoother, not to mention less time consuming.
How do we achieve this miracle? It's not as complicated as you might think. First add some category fields to your chart:
Add the fields you want to appear in the chart to the Category field underneath each other.
Next, create the first bookmark by selecting the chart:
I've gone with Selected visuals and only selected the chart so that slicers on the page won't be included.
To create the second chart I need to have Quarter as the chart focus:
Use the second option of drill down to skip a level. This will create a chart based on the second level in Category, independent of the first. Data must be ticked.
Now attach these bookmarks to suitably named buttons, image or shapes:
That's it, the whole thing. Still several bookmarks but this time only one chart!
Even better, with this method the fields don't even need to be related for it to work:
Go as crazy as you like. If only the Y axis was so adaptable....
To see the finished report in all it's glory, click here.