Forum Discussion

DavidK85's avatar
DavidK85
Frequent Visitor
2 years ago
Solved

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 t...
Need Help
  • Ajithkumar_03's avatar
    Ajithkumar_03
    2 years ago

    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's avatar
bhanu_gautam
Super User
2 years ago

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's avatar
DavidK85
Frequent Visitor
2 years ago

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

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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