Forum Discussion
Percentage Difference in Dashboard Table
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
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
4 Replies
- bhanu_gautam
Super User
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
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
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
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
