Design Power BI reports people actually read
Most reports don't fail on DAX. They fail because nobody finds the answer in five seconds. Below is a report exactly as Power BI builds it. Fix it yourself, one setting at a time.
- A real default report
- Real sales data
- Fix it yourself
Redesign this report
Power BI built this page from the default settings. Change them on the left and watch the page change.
0 of 7 fixed
- 1
Give the page a title
The page has no title. Type one that says what the page answers.
In Power BI: Insert → Text box. For a subtitle that follows the slicers, use a card on a text measure.
- 2
Fix the KPI cards
Profit Margin shows 0.14, and no card says if the number is good. Fix the format and add a comparison.
In Power BI: Measure tools → Format: Percentage, 1 decimal. On the card: Format → Reference labels → add a measure for last year.
- 3
Fix the trend
Sales by Year is two points. Use the field that shows every month.
X-axis fieldIn Power BI: In the X-axis well, open the arrow next to the date field and choose Date instead of Date Hierarchy. Add the average line in Analytics → Average line.
- 4
Make the loss stand out
Five same-color columns. Turn on what makes the losing segment obvious.
In Power BI: Format → Columns → Color → fx → Rules: red when the value is below 0. Turn on Data labels.
- 5
Replace the pie
Five slices between 17.6% and 21.1%. Pick a visual that shows the ranking.
Visual typeIn Power BI: Pick another type in the Visualizations pane, then add Profit to the X-axis well next to Sales for a clustered bar.
- 6
Clean up the table
Raw numbers sorted by name. Make them readable and put the biggest first.
Sort byIn Power BI: Format each measure with a format string like #,0.0,,"M". Click a column header to sort. Data bars: Cell elements → Data bars.
- 7
Apply the company theme
Every report in the company uses the Corporate blue theme. Apply it.
ThemeIn Power BI: View → Themes → Browse for themes, and pick the company's JSON theme file. Every visual switches at once.
Scroll sideways to see the whole page.
Report redesigned.
Same data, same fields. Now do it in our full Power BI practice simulator, step by step.
Each fix in more depth
The settings, the DAX and the reasons behind them.
- Start here3 min readPower BI dashboard design best practices: 9 rules with before and afterRead the guide
- Layout2 min readPower BI report layout: where to put KPIs, charts and slicersRead the guide
- Charts2 min readWhich Power BI chart should you use? A simple guide with examplesRead the guide
- KPI cards2 min readPower BI KPI cards: how to make headline numbers people trustRead the guide
- Color2 min readPower BI color theme: a clean palette and a theme file you can importRead the guide
- Examples3 min readPower BI dashboard examples, and the design rules behind themRead the guide
Practice on real reports
Each lesson opens a report in our Power BI practice simulator. You cut clutter, rewrite titles, recolor, rebuild the wrong charts, and fix measures that show the wrong numbers. Every step is checked.
Report design
- 1One page, one storyPlan a report page the way readers scan it: the key number first, then the trend, then the detail.
- 2Titles that say somethingReplace "Total Profit by Segment" with the finding, so the chart explains itself.
- 3Color that means somethingOne calm color for everything, and a strong one only where the reader must look.
- 4The right chart for the questionFix a page that uses the wrong visuals: lines for categories, pies with too many slices.
- 5Numbers people can readRatios as percentages, a heat map instead of a wall of numbers, and the right amount of detail.
Fix the dashboard
- 1The numbers don't add upA finished sales report goes to the board tomorrow. Two measures are wrong: find and fix them.
- 2Four things the manager asked forExtend a finished report: a segment filter, a trend, labels and a detail table with a heat map.
- 3The year-on-year numbers are wrongThree time intelligence measures each have one classic mistake. Find them and fix them.
- 4Repair the query behind the reportThe report counts units twice. Find the problems in the inherited Power Query steps and repair them.
- 5Finish the sales dashboardA designed sales dashboard is half built. Fill the four empty tiles so it answers what the sales team asks.
- 6Finish the profit reviewThe profit review has its layout and cards. Build the missing measure and the three visuals that explain the margin.
- 7Finish the year-on-year dashboardThe layout and the sales chart are ready. Write the two time measures the tiles need, then fill them.