Year on Year Data with Filter/Slicer on year.

[Anonymous]

Hi,

I'm very new to Power BI having troubles with DAX expressions.

I'm trying to get two different visuals where one is supposed to show current year and other one is Y-O-Y Trend , but we need a filter it could be a page filter or slicer.

Something like below.

I tried creating an measure like 

Atest = CALCULATE(sum(data[ExternalRevenue]),ALL(data[YEAR]))

But despite this it is showing data for only 2020.

Note: I undertand that we can use slicer and delink with the chart where trend is required but that's not what we want.

Regards,

Mohan

[Pragati11]

Hi @Anonymous ,

What happens when you clear slicer selections in YEAR slicer? Does it show you all years data?

Try modifying your measure as follows:

Atest = CALCULATE(sum(data[ExternalRevenue]),ALL(data))

Thanks,

Pragati

[Anonymous]

Hi @Pragati11 ,

I tried the calculation you mentioned but it gives same result.

If we remove slicer the chart shows data for 2019 and 2020.

Regards,

Mohan

[Pragati11]

Hi @Anonymous ,

Just wanted to check, in your screenshot I see 2020 is selected in the slicer, therefore it shows 2020 data.

When you clear 2020 from slicer, it should show every year on the chart.

So, now my question is what is the requirement?

Thanks,

Pragati

[Anonymous]

HI @Pragati11 ,

My requirement is that we need a filter for year, and the report will have a tile for current year data and a chart that shows Y-o-Y comparison. When user selects 2020 it should data for 2020 in tile and 2019 and 2020 data in chart. They can select any year the tile should show the data for year selected and chart should show Y-o-Y comprison.

Regards,

Mohan