Forum Discussion
Card Visual
I want to use the Card visual to show the total hours worked for support calls for when a category is selected e.g., Software, Hardware, etc.. Each request has an ID assigned, however, there may be multiple entries for the same request. Example, Request ID#353 has 12 hours recorded on 10/1/2021 and another entry on 10/15/2021 for 2 hours. Total hours worked for Request ID#353 is 14 Hours. How can I use the Card visual to show total hours? Or is there another visual I should use?
9 Replies
As long as your model has appropriate relationships defined you can just drag the 'Total Hours' column to the card.
Sample PBIX attached.
Hi Anonymous
Thanks for reaching out to us.
Is there any relationship between the 2 tables?
If it has one to many relationship, then you can set the summarization of field [hours] to Sum, then put the field [hours] into Card visual.
If there's no relationship, you can create this calculated measure and put it in Card,
Total Hours = CALCULATE(SUM('support calls'[hours]),FILTER('support calls','support calls'[category ]=SELECTEDVALUE(Category[category ])))Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Here's another way I'd like to present this problem. I have one table that I want to display the # of hours and minutes worked. When selecting each of the subcategories, I do see the sum of hours worked (top box), however, if I want to display the time as "hours" and "minutes", I don't get the same results (bottom box).
Lots of different ways to approach this.
This video shows one that you should be able to adapt to your needs.
https://www.youtube.com/watch?v=Z1hGU93UE1c&ab_channel=NestorAdrianzen
EDIT: another good option, https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
