The business wants to track too many KPIs on one dashboard. How do you push back?

< 1 min read

First, I would understand the purpose of the dashboard and the key decisions the business wants to support.
I would review the list of KPIs and identify which ones directly relate to those decisions.
Then I would explain that too many KPIs can create visual clutter and make it harder for users to focus on the most important insights.
For example, in one project stakeholders initially requested more than 20 KPIs, which made the dashboard difficult to read.
I suggested prioritizing a small set of core KPIs for the main dashboard and moving the rest to secondary views or detailed reports.
This allowed the main dashboard to remain clear and focused.
I would work with stakeholders to categorize KPIs into primary, secondary, and drill-down metrics.
Finally, I would demonstrate a prototype layout so they can see how a focused dashboard improves usability and decision-making.

Power BI Essentials