Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I want to be able to display time durations hh:mm:ss in a visual like a bar chart.
The reason for this is we track our sales team on call times and we want to be able to track it month on month, year on year, day on day etc, and I feel like the best way to do that would be to use a bar chart. Currently the only way to show the data is in a Card and I feel they're fairly limited in their capabilities.
I have created a measure that shows the average and that's what I want, no problems there. I am just having problems displaying that data
I'll include a PBIX file with some test data.
https://www.dropbox.com/s/4pbc79tpo9yg59a/help.pbix?dl=0
Any help appreicated
Thanks,
Mike
Solved! Go to Solution.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639
Cheers @Greg_Deckler
That looks good! Just so I'm right, does that mean I need to break up my current column from hh:mm:ss into seconds and then build it back up into hh:mm:ss?
If so, how would I go about breaking it down?
Hi @michael_knight ,
Do you mean like this? If so, you could try to change the type of X asix to Categorical.
Please see the attachment for more details.
Hi @v-xuding-msft ,
No, I don't mean like that.
I mean like on the X axis it's dates like Monday, Tuesday Wednesday etc, or January Febraury March etc, and then the Y Axis the call times from that period of time
Cheers
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |