Power BI report design

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.

Your turn

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. 1

    Give the page a title

    The page has no title. Type one that says what the page answers.

  2. 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.

  3. 3

    Fix the trend

    Sales by Year is two points. Use the field that shows every month.

    X-axis field

  4. 4

    Make the loss stand out

    Five same-color columns. Turn on what makes the losing segment obvious.

  5. 5

    Replace the pie

    Five slices between 17.6% and 21.1%. Pick a visual that shows the ranking.

    Visual type

  6. 6

    Clean up the table

    Raw numbers sorted by name. Make them readable and put the biggest first.

    Sort by

  7. 7

    Apply the company theme

    Every report in the company uses the Corporate blue theme. Apply it.

    Theme

Sum of Sales118.73MSum of Profit16.89MProfit Margin0.14Sum of Units Sold1.13MSum of Sales by Year0M50M100M20132014YearSum of SalesSum of Sales by Segment118.7MtotalGovernment44.2%Small Bus.35.7%Enterprise16.5%Midmarket2.0%Channel P.1.5%Sum of Profit by Segment0M5M10MSum of ProfitSegmentGovernmentSmall Bus.Channel P.MidmarketEnterpriseSum of Sales by Country25.03M (21.08%)24.89M (20.96%)24.35M (20.51%)23.51M (19.80%)20.95M (17.65%)CountryUnited Sta…CanadaFranceGermanyMexicoProductSum of SalesSum of ProfitAmarilla17747116.052814104.05Carretera13815307.891826804.89Montana15390801.882114754.88Paseo33011143.954797437.94Velo18250059.472305992.47VTT20511921.023034608.02Total118726350.2616893702.25OverviewProductsDetailFilters

Scroll sideways to see the whole page.

Free guides

Each fix in more depth

The settings, the DAX and the reasons behind them.

Hands-on lessons

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

  1. 1One page, one storyPlan a report page the way readers scan it: the key number first, then the trend, then the detail.
  2. 2Titles that say somethingReplace "Total Profit by Segment" with the finding, so the chart explains itself.
  3. 3Color that means somethingOne calm color for everything, and a strong one only where the reader must look.
  4. 4The right chart for the questionFix a page that uses the wrong visuals: lines for categories, pies with too many slices.
  5. 5Numbers people can readRatios as percentages, a heat map instead of a wall of numbers, and the right amount of detail.

Fix the dashboard

  1. 1The numbers don't add upA finished sales report goes to the board tomorrow. Two measures are wrong: find and fix them.
  2. 2Four things the manager asked forExtend a finished report: a segment filter, a trend, labels and a detail table with a heat map.
  3. 3The year-on-year numbers are wrongThree time intelligence measures each have one classic mistake. Find them and fix them.
  4. 4Repair the query behind the reportThe report counts units twice. Find the problems in the inherited Power Query steps and repair them.
  5. 5Finish the sales dashboardA designed sales dashboard is half built. Fill the four empty tiles so it answers what the sales team asks.
  6. 6Finish the profit reviewThe profit review has its layout and cards. Build the missing measure and the three visuals that explain the margin.
  7. 7Finish the year-on-year dashboardThe layout and the sales chart are ready. Write the two time measures the tiles need, then fill them.
Start the first design lesson