Need help with data modelling

[Anonymous]

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

[zoloturu]

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

[Anonymous]

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

[Anonymous]

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.

Unpivot columns (Power Query) 

Regards,

Xiaoxin Sheng