I am hoping someone could suggest me a way to create a clustered column chart comparing values for two different date ranges from a single date column.
I have a table with a date cloumn, with data from October 2015 to October 2017. I would like to draw a clustered column chart comparing monthly data for two date ranges. i.e. 1)from 27-oct-15 to 26 Aug 2016 and 2) from 27-oct-16 to 26- Aug- 2017.
Here is the visual with the monthly data for the date range 27-oct-16 to 26-Aug-17:
Below is the Axis parameters used for the above graph:
I would like to add/compare the monthly data for date range (27-oct-15 to 26 Aug 2016) to the above column chart. Any help would be very much appreciated. Thank you!!!
@v-huizhn-msft, @CheenuSing Thanks for your help!! I am able to view current year totatls with the past year(Fiscal Year2) totals by using the measure you suggested.
Additionally, 1)Is there also a measure where I could see the past two year totals(Fiscal year1&2) with the current year? 2) How could I reformat the dates on my chart to start from (Oct16- August17) ?