Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi experts,
I have a data here containing Station 1,2,3,4. Each station has multiple operation codes with a work order. I need to present the status with Completed (in Green), In Progress (in Yellow) and Not Started (in Red).
What is the best chart to do it? Other than that, to make it more interactive, i need to include the total number of vehicles assigned to this station, and i would like to do it in a way to include vehicle icons for better visualization effect.
Here's a sample data:
Station | Operation | WO | Status | Total Vehicle |
1 | 1000 | 123456 | Done | 2 |
1 | 1001 | 123456 | In progress | 2 |
1 | 1002 | 123456 | Done | 2 |
1 | 1003 | 123456 | Not Started | 2 |
2 | 1000 | 234567 | Done | 3 |
2 | 1001 | 234567 | Done | 3 |
2 | 1002 | 234567 | Not Started | 3 |
2 | 1003 | 234567 | In progress | 3 |
3 | 1000 | 345678 | Not Started | 2 |
3 | 1001 | 345678 | Not Started | 2 |
3 | 1002 | 345678 | Done | 2 |
3 | 1003 | 345678 | Done | 2 |
4 | 1004 | 456789 | Not Started | 1 |
4 | 1005 | 456789 | In progress | 1 |
4 | 1006 | 456789 | Done | 1 |
4 | 1007 | 456789 | Done | 1 |
4 | 1004 | 456789 | Done | 1 |