Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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).

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi Anonymous 

Thanks for your reply.

I didn't reproduce the problem, could you provide a sample file for us to test?

 

 

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Here are my latest findings.   I've tried multiple attempts and can not get the desired outcome.   First, the Card does not dynamically change when selections are made on the table.   Second, time over 24 does not represent well with my example.   Below I have an example of the excel sheet showing events over 24 hours.  Next to that is how PowerBI displays the information both in the Table and Card when I use "Time Worked".

    • KNP's avatar
      KNP
      Super User
      4 years ago

      Anonymous - it looks like you're creating a calculated column, you may need to create this as a measure if you want it to be responsive to other interactions. Have a look at the links I posted above and try creating it as a new measure.