Forum Discussion
Progress or Status Chart
- Anonymous1 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 itFinal output
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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
- ngsolanki1 year agoRegular Visitor
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