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

     

     

     

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