Forum Discussion

ngsolanki's avatar
ngsolanki
Regular Visitor
1 year ago
Solved

Progress or Status Chart

Hello,

I am seeking assistance in tracking the status of the manufacturing process for batches in Power BI. I would like to visualize the manufacturing steps on the X-axis and the batch numbers on the Y-axis, with each point indicating the corresponding status.

I have attached an example for reference. Any help or guidance would be greatly appreciated.

Thank you in advance!

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ngsolanki ,
    As I mentioned above, regarding the x-axis sorting follows numerical or alphabetical order, so you can create a column that contains an index.

    Index_Status = 
SWITCH(
    TRUE(),
    'Table'[Status] = "Coc",CONCATENATE("1_",'Table'[Status]),
    'Table'[Status] = "Tablet EBR reivew",CONCATENATE("2_",'Table'[Status]),
    'Table'[Status] = "Tablet Manufacturing",CONCATENATE("3_",'Table'[Status]),
    'Table'[Status] = "HME Manufacturing",CONCATENATE("4_",'Table'[Status]),
    'Table'[Status] = "Shipped",CONCATENATE("5_",'Table'[Status])
)


    Then for the y-axis you can't do a precise creation of a category, but you can set the level for it



    Final output

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

     

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

    Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

    Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

    Please show the expected outcome based on the sample data you provided.

    Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

    • ngsolanki's avatar
      ngsolanki
      Regular Visitor
      1 year ago

      HI Ibendlin, 

       

      Please see below for data set, really small data set.

       

      That process flow as following- HME manufacturing --> HME release --> HME EBR review --> Tablet manufacturing --> Tablet Release -->Tablet EBR review --> shipping 

       

      I wanted to have the chart as I shown ealier but I am open to ther ideas as well. 

       

      Thanks,

       

      Batch Status 
      2401365Tablet EBR reivew 
      2402365HME Manufacturing 
      2409687CoC
      2410758Shipped 
      2411788Tablet Manufacturing 
      2412799Tablet EBR reivew 

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi ngsolanki ,
    Based on your description, you can try to build a visualization using a scatterplot, on the y-axis you need to make sure that your batch number is of numeric type, of course the y-axis is separated by equal quantities so it won't be able to display your batch number exactly as it is, but you can mouse over the scatter in order to determine the batch number. For the x-axis, the default order is numerical or alphabetical, but if you want to display by process, you can prefix all your processes with a sequential number
    Scatter, bubble, and dot plot charts in Power BI - Power BI | Microsoft Learn

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • ngsolanki's avatar
      ngsolanki
      Regular Visitor
      1 year ago

      Hi Anonymous 

       

      Thank you for looking into it. I was able to do somethign like this but the x-axis is sorting and process flow is not right. Is there a way to fix the flow? Is there a way to make y-axis categorical? 

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi ngsolanki ,
        As I mentioned above, regarding the x-axis sorting follows numerical or alphabetical order, so you can create a column that contains an index.

        Index_Status = 
SWITCH(
    TRUE(),
    'Table'[Status] = "Coc",CONCATENATE("1_",'Table'[Status]),
    'Table'[Status] = "Tablet EBR reivew",CONCATENATE("2_",'Table'[Status]),
    'Table'[Status] = "Tablet Manufacturing",CONCATENATE("3_",'Table'[Status]),
    'Table'[Status] = "HME Manufacturing",CONCATENATE("4_",'Table'[Status]),
    'Table'[Status] = "Shipped",CONCATENATE("5_",'Table'[Status])
)


        Then for the y-axis you can't do a precise creation of a category, but you can set the level for it



        Final output

         

        Best regards,
        Albert He

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly