Forum Discussion
Selective display of data in visualisation
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?
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.
1 Reply
- mangaus1111
Solution Sage
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.