Forum Discussion

aboodhamwi's avatar
aboodhamwi
Frequent Visitor
9 years ago
Solved

Percentage between 2 cards

Hi i have 2 values inside 2 cards and i need third one with the percent of the diffrence between 2 cards   so any assistence how can i make it 
Show and Tell
  • SwaroopRoyM's avatar
    SwaroopRoyM
    9 years ago

    Hi,

     

    Yes, if you're pulling the first and second columns from some table/view then caluclate the diff. % as third column. You can try doing this in the backend (if you're using SQL server) or in Power BI as New column/Measure. Then append the "%" sign to it and use a multi-level card to display all three values.

     

    Hope this is clear?

     

    Thanks,

    Swaroop

aboodhamwi's avatar
aboodhamwi
Frequent Visitor
9 years ago

Hi

these was the Result

RafaelSantos87's avatar
RafaelSantos87
Regular Visitor
8 years ago

Hello! I have the same doubt, how did you manage to reach the percentage? What function did you use?