How to choose and show data comparing two years

[zervino]

I have data with this structure:

And I would like to show this in Power BI:

How can I achieve this?

The idea is to have some slicers to select the two years to compare (so I could choose 2019 vs 2022 or 2020 vs 2023, etc)

[v-zhangti]

Hi, @zervino 

You can try the following methods.

In the Power Query-Select the first two columns-Unpivot other column:

Measure:

Minyear value = Var _minyear=CALCULATE(MIN('Table'[Year]),ALLSELECTED('Table'[Year]))
Return
CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Year]=_minyear&&[Attribute]=SELECTEDVALUE('Table'[Attribute])))

Maxyear value = Var _maxyear=CALCULATE(Max('Table'[Year]),ALLSELECTED('Table'[Year]))
Return
CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Year]=_maxyear&&[Attribute]=SELECTEDVALUE('Table'[Attribute])))

YOY = [Maxyear value]-[Minyear value]

YOY% = [YOY]/[Maxyear value]

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[gmsamborn · Accepted solution]

Hi @zervino 

Would something like this help?

Compare selected years.pbix

[zervino]

Thank you, that works perfect.