Progress or Status Chart

[ngsolanki]

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!

[Anonymous]

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]

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 · Accepted solution]

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

[lbendlin]

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

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/1447...

[ngsolanki]

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
2401365	Tablet EBR reivew
2402365	HME Manufacturing
2409687	CoC
2410758	Shipped
2411788	Tablet Manufacturing
2412799	Tablet EBR reivew