Percentage Difference in Dashboard Table

[DavidK85]

Hi,

I have created a table on my dashboard (below) showing the sum of values for each month in 2023 and 2024. I'm looking to create a column that will give me a percentage rise/fall between the two years. Is this possible?

Thanks

[Ajithkumar_03]

Hi @DavidK85 

Please refer the below screenshot you can show this view bco'z in matrix visual not possible your requirement.
you can show the % differene between current and previous year dynamically.

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Best Regards,
Ajith Kumar

[bhanu_gautam]

@DavidK85 , You can try below measure

Percentage_Rise_Fall =
VAR Sum_2023 = [Measure for sum of values in 2023]
VAR Sum_2024 = [Measure for sum of values in 2024]
RETURN
IF(ISBLANK(Sum_2023) || ISBLANK(Sum_2024), BLANK(),
(Sum_2024 - Sum_2023) / Sum_2023 * 100)

If you are using measure for values in 2023 and 2024 replace it in the formula

[DavidK85]

@bhanu_gautam 

Thanks for the reply, I'm not using measures to get the total for the years so I don't think it works. This is what I have for my columns and rows if it helps

[v-yaningy-msft]

Hi, @DavidK85 

Thanks for @bhanu_gautam reply. Have you solved your problem yet? If not, you can share your complete pbix file without sensitive data and the final result you want to achieve, which will help you to solve the problem faster.

Best Regards,
Yang
Community Support Team