Forum Discussion
Power BI work order dashboard
I am creating a work order dashboard for my department to track the closeout of compliance items from our federal inspection. The only data field that we can use to track open or closed in power BI ...
You can do it with Power Query. Click on the Transform Data button in the Home ribbon menu and it will take you there.
ray_aramburo
Super User
Super UserYou would need to create a conditional/custom column with a logic you define to determine what's closed and what's open depending on the dates or other criteria.
Excuse my ignorance if this is a dumb question, but our data feed is automatic from the database. Ive never seen a spreadsheet containing the data. is this still an option?
- ray_aramburo
You can do it with Power Query. Click on the Transform Data button in the Home ribbon menu and it will take you there.