Forum Discussion

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

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

5 Replies

SwaroopRoyM
Helper II
9 years ago
Hi,

You can use a multi-level card visual, in which you can put all three values including the difference %. Do the calculations in the Power BI dataset itself.

Thanks,
Swaroop
- aboodhamwi
  Frequent Visitor
  9 years ago
  Hi, Thanks for replying
  excuse me but i'm new with power bi
  you mean should i create new column to hold this value
  what the first card meaning is
  first one is the total visit count (row count) in the running month
  second one is the total visit count (row count) with status completed for that month
  i need third one to get the Completion percentage of the visit per month so how can i add this value to a column
  - SwaroopRoyM
    Helper II
    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

Related content