Selective display of data in visualisation

[Anonymous]

Hello,

This is my current display of data:

This is how I would like the visualisation to look like:

I would like to remove the % change for 2021 and Total as it doesn't really make sense as I am not displaying 2020's data.

I have selecting the % Change column for 2021 and right clicking to hide, but the whole of 2021 just disappears.

Is there a way in which I can onlydisplay the % Change for 2022?

[mangaus1111 · Accepted solution]

Hi @Anonymous ,

you need to use these 3 measures and you have to use a calendar table related to the Sales table:

Rev 2022 = CALCULATE(SUM(Table[Rev]),Calendar[Year] = 2022)

Rev 2021 = CALCULATE(SUM(Table[Rev]),Calendar[Year] = 2021)

%Change = DIVIDE([Rev 2022] - [Rev 2021], [Rev 2021])

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