Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    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.

mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
3 years ago

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.