Show this year and last year when slicer is on current year

[mmpbi]

I have an indicator (let's say profit as a percentage of revenue) of which I want to display (the current month) for curent year and the previous year in a barchart. However, I want to use a slicer to define what "the current year" is. If the slicer is set to 2019, I want to see 2 bars, one with 18 and one with 19. If the slicer is set to 16, I want to see 15 and 16 etc.

I managed to do this with 2 seperate measures in the value field of the barchart (the one for the previous year below), however, that results in the same legend/axis label for the year: it always only shows the one for the "sliced" year.

%Profit M-1Y = 
VAR YearMonth = 
Calculate(Max( DimDate[YearMonth] ), Month( DimDate[ActualDate] ) = Month( ToDay() ) ) - 100 Return
 
//DimDate[YearMonth is something like 202101 for january 2021
Calculate( Profit[%Profit], Filter( All( DimDate), Int(Value(DimDate[YearMonth])) = Int(YearMonth) ) )

(The measure for current year is identical, without the -100.)

Is there any way to do this just using only a single measure, overriding the slicer?

Thanks in advance!

[Anonymous · Accepted solution]

Hi @mmpbi,

If you want to achieve a custom filter range that different from you operation on the slicer, you need to ignore the filter effect from slicer to your table.
Then you can write a measure to check current row contents and compare with extracted slicer selection items to return tag. After these steps, you can use this measure as a visual level filter to filter records.

Applying a measure filter in Power BI 

Regards,

Xiaoxin Sheng

[Ashish_Mathur]

Hi,

See if you can get some help from my article here - Flex a Pivot Table to show data for x months ended a certain user defined month.

[mmpbi]

Thanks for your reply, but I do not see how this solves my solution. It's about and excel and only remotely related.