Forum Discussion

BIUser1998's avatar
BIUser1998
Icon for Helper I rankHelper I
2 years ago

Compare two matrix tables from the same data table and show percentage difference

I have created two matrix table visualizations from the same data table and I want to show the percentage difference between each value in a third table. How do I achieve this? I am new to PowerBI so this is something that is quite new to me. Any leads would be appreciated. Thank you

Need Help

2 Replies

  • Data-estDog's avatar
    Data-estDog
    Icon for Resolver II rankResolver II
    2 years ago

    You've been super vauge, with no data and no examples. Do this going forward: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

     

    But I'll take a shot in the dark:

    Create a measure subtracting each of the corrisponding columns. If matrix 1 is for 2022 and matrix 2 is for 2023, and one of the columns is total sales. Create a measure with the following definition:

     

    Measure = calculate(sum(totalsales), year = 2023) - calculate(sum(totalsales), year = 2022) 

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    2 years ago

    Hi, BIUser1998 

     

    Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.