Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need help with data modelling

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

 

 

Need Help
Tips and Tricks

3 Replies

  • zoloturu's avatar
    zoloturu
    Memorable Member
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello Ruslan,

       

      Below you find an example of the dataset without any formatting. Is this enough info for you? 

       

      Kind regards, Sander

       

      Call number

       
      		PriorityAcceptation timeResponse timeSecure timeRestore timeResolve time
      Call 1Urgent01:19:2101:19:2113:59:0513:59:0513:59:05

      Call 2

      		Very Urgent00:16:0801:07:4907:13:1807:13:1807:13:18
      Call 3Normal00:09:13 18:51:3322:03:2222:03:2222:03:22

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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