Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
Hi @cel ,
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.
Hi @cel ,
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.
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |