Forum Discussion
Column Chart - Past 6 Months
How would you show the last 6 months on a column chart (on the X axis). So if I want to show the previous 6 months of April I want it to appear as the following Nov > Dic > Jan > Feb > Mar> Apri...
Just create a measure that will return 1 for the months you want to display and BLANK for others and then filter the visual by this measure.
More specifically, the measure should sense the last month in the current context and make sure that for the 6 last months it returns 1 and for all others 0 (or BLANK). Then filter the visual by setting the measure's value to 1.
Best
D
More specifically, the measure should sense the last month in the current context and make sure that for the 6 last months it returns 1 and for all others 0 (or BLANK). Then filter the visual by setting the measure's value to 1.
Best
D