cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aboodhamwi
Frequent Visitor

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

Untitled.png

 

so any assistence how can i make it 

1 ACCEPTED SOLUTION

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

View solution in original post

5 REPLIES 5
SwaroopRoyM
Helper II
Helper II

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

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

 

 

 

 

 

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

View solution in original post

Hi

these was the Result

Untitled.png

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.