Forum Discussion
Monthly Chart Total Relative to Year
Is there a way to make the axes of a bar chart relative to the selection of another visual?
For example, let's take a simple sales report with two bar charts. One bar chart shows total sales by year and the second by month. By default, if you click a year the month chart will still show the original scale (ie total sales across all years by month) with shaded bars.
What I'd like to accomplish is for a selection on the year chart to cause the month chart to redraw its axes so that there is no shaded bar and the remaining bars are not tiny slivers on the chart.
Possible?
Select the bar chart with year data, menu>Format> and Click in Edit Iteractions.
Will show 3 signs above you second bar chard, chose the first one who looks like a "filter". I think that it solve.
If it solve your problem, please mark as solved and give your positive feedback.
Rafael Mendonça
MCSA Bi Reporting
www.youtube.com/rafaelmendonca
1 Reply
Select the bar chart with year data, menu>Format> and Click in Edit Iteractions.
Will show 3 signs above you second bar chard, chose the first one who looks like a "filter". I think that it solve.
If it solve your problem, please mark as solved and give your positive feedback.
Rafael Mendonça
MCSA Bi Reporting
www.youtube.com/rafaelmendonca