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 t...
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

     

     

     

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