Dashboards fail because nobody designs them to decide. Treat them as UX.
Your dashboard isn't broken because the data's incomplete; it was never designed to move anyone to act. This piece maps data visualisation onto UX — same job of moving the right information to the right person so something changes — and shows how framing charts around a real question, not what data was handy, is what turns a room of nods into a decision.