I am creating a budget dashboard, but one of the requirements is to be able to flip through Monthly, Quarterly and Annual numbers/visualization.
I am having difficulty visualizing this on a time line, because the x-axis is fixed to month & year (the base periodicity of the underlying data).
When I switch to quarter and annual version, there are 3 bar (column chart) for each quarter, and 12 bars for each year.
Ideally I would like the chart to dynamically change the x-axis to quarter & year, and year, so there is respective number of bars on the charts.
Is this a possibility? Based on my google search, the only option I saw was to create multiple version of the values and using slicers to show/hide the columns.
Kindly let me know if there is more clean and straight forward way to achieve this.
Thank you for all your help!