Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have Data which shows Created date, Change Date and Progress Time(Custom Added column giving difference of Change and created) along with State and Category.
I want to visually represent Average time under each state giving filter to Category. Basically my visual should answer. How much is the average time to convert a workitem to Development for each category .
ID | Category | Created Date | Change Date | ProgressTime | State |
1234 | A | 1/1/2020 | 10/1/2020 | 10 days | Development |
5678 | B | 2/1/2020 | 13/1/2020 | 11 days | Prod |
9112 | C | 5 | New | ||
1314 | D | 7 | Prod | ||
3566 | A | 3 | Development | ||
9826 | A | 8 | Production | ||
9864 | C | 1 | Development | ||
0981 | B | 0 | New | ||
7860 | C | 10 | Development |
What is the right visual to represent Progress over time and if we have a target of converting a workitem in 1 day it can tell how ahead or behind are we from target . Need to understand which visual can help showcase the picture efficiently
Hi @GunjanKathuria ,
In this case believe that the option can be clustered column chart:
This also depends on the way you have your story telling.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português