Forum Discussion
Percentage between 2 cards
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
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
Hi
these was the Result
Hello! I have the same doubt, how did you manage to reach the percentage? What function did you use?
