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 friends,
Another problem:
I have a service contract with 3 types of calls (Normal, Urgent, Very Urgent)
Furthermore, each call has 5 different 'stages' and depending on the call priority the Service Level Agreement time each stage has his own timeframe in which the call needs to be Looks like the first visual below.
For each type of call I need to report the number of calls that were handled in time in each phase. I already made something in Power BI, but I did all kind off data transformation in xls. I think it should be possible without the transformations in xls and do all the transformations in Power Query. But I have no clue. Does anyone has an idea how I can create a page like this without any data transformation in xls?
Hope to hear soon from you!
Cheers, Sander
Example of data:
My own creation (with the help of xls):
Hi @Anonymous ,
Please provide how your initial data is look like.
And of course, I'm sure for 99% that all transformations from Excel can be done at PowerQuery inside of Power BI.
Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!
You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups
Hello Ruslan,
Below you find an example of the dataset without any formatting. Is this enough info for you?
Kind regards, Sander
Call number | Priority | Acceptation time | Response time | Secure time | Restore time | Resolve time |
Call 1 | Urgent | 01:19:21 | 01:19:21 | 13:59:05 | 13:59:05 | 13:59:05 |
Call 2 | Very Urgent | 00:16:08 | 01:07:49 | 07:13:18 | 07:13:18 | 07:13:18 |
Call 3 | Normal | 00:09:13 | 18:51:33 | 22:03:22 | 22:03:22 | 22:03:22 |
Hi @Anonymous ,
I'd like to suggest you use 'unpivot column' on your time fields to convert them to attribute and value, then you can simply use visual level filter to control what type of DateTime display on your visual.
Regards,
Xiaoxin Sheng
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 |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |