Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataHard
A sales director wants a Power BI dashboard that provides a high-level overview of sales performance. The dashboard needs to display key metrics like total sales, average order value, and profit margin using simple, prominent visuals. Additionally, the director wants to easily see the current month's performance at a glance without needing to interact with filters. Which combination of visual types and report design principles would achieve this effectively?
- ACard visuals for key metrics and a Table visual for detailed monthly data.
- BCard visuals for key metrics with a default current month filter applied to the page.
- CA Pie Chart for total sales by category and a Bar Chart for profit margin by region.
- DMultiple Line Charts and a Slicer for months.
Show answer & explanationAnswer & explanation
Correct answer: B. Card visuals for key metrics with a default current month filter applied to the page.
Card visuals are perfect for displaying single, prominent key metrics. By applying a page-level filter for the 'current month' by default, the cards will automatically show the desired performance without user interaction. This combination meets both requirements for high-level overview and immediate current month visibility.
Why the other options are wrong
- A. While Card visuals are good for key metrics, a Table visual for detailed monthly data does not provide the 'at a glance' current month performance without interaction, as the user would still need to scan the table.
- C. Pie and Bar charts are for categorical breakdowns, not for prominent, single key metrics. They also don't inherently address the 'current month at a glance without interaction' requirement.
- D. Line charts are for trends, not single prominent metrics. A slicer would require user interaction, which goes against the 'at a glance without interaction' requirement.
Dashboard Design for KPIs
Designing a Power BI dashboard to effectively display Key Performance Indicators (KPIs) using prominent visuals and default filtering to provide an immediate overview of critical metrics.
- Use Card visuals for single, important numbers.
- Apply default filters for specific time periods (e.g., current month).
- Aim for clarity and minimal interaction for high-level overviews.
Memory trick: Cards for KPIs, filter for now, executive insights, clear somehow.