There are many times a user may only want to see one specific plot at a given point in time. In this scenario, you can create all the different types of plots a user may want to see and link them from a cover page using bookmarks.
However, it takes a lot of real estate to have all visualizations in a file. One option would be to use Property Controls and expressions to dynamically configure/create the visualization when the user needs it.
Assume the consumer may want to look at a cumulative sum, a 4 period rolling average, or a year-to-date rolling average.
For all these plots the x-axis would be the same, possibly a Date hierarchy for example.
We can then create a drop-down list Property Control where the drop down values are set via expression.
Then for each value we can enter the expression we want to appear on the Y-axis as well as a user friendly display name to be used in the property dropdown list. The screen shot below depicts a Cumulative Sum expression being used.
Once you are done adding all the values you want, you then need to attach the property control to the y-axis expression as shown below.
The end result is a drop down list which changes the Bar Chart to display either a Cumulative Sum, 4 period average, or a YTD rolling.
