Comparing this year and last year measure on a bar chart

[AliSharifi]

Hi,

I'm going to show a meaure values of this year and last year on a bar chart. I created a new measure in PowerBI Desktop with this formula:

The problem is when I use a Time Slicer and select a year, The calculated measure be disapeared and It sounds the last year data getting filter out from the dataset:

I can see the OrderQuantityLY just when more than 1 year is selected:

Any suggestion?

Thanks,

Ali

[Sean · Accepted solution]

@AliSharifi Create a clustered column chart

In the Axis - enter CalendarMonth (this should be a field from the DimDate table that represents just the months)

In the Legend - enter CalendarYear (again from the DimDate table the field that represents just the years)

this field CalendarYear should be the same field you use for the Slicer

In the Value - enter this measure OrderQuantity = SUM(FactInternetSales[OrderQuantity])

This will create a chart that will show 12 columns - overall totals for Jan thru Dec for all years

Then select as many years in the slicer as you wish - you will get that many columns for each month

this works with line charts too and you can select any years to compare not just consecutive