Power BI Table Formatting: Headers, Totals and Conditional Signals

Power BI lesson: table formatting

Original diagram created for this blog.

Format in layers

1. Use a clear title and readable column names.
2. Format Amount as currency and Units as a whole number.
3. Use a subtle header background and enough row height.
4. Keep totals visible when they answer the report question.
5. Use conditional formatting for emphasis, not decoration.

Data bars and icons

Data bars show relative size inside a numeric column. Icons can flag values above or below a rule. Explain your rule in the report so readers do not have to guess.

Practice

Format a SalesPractice table with a currency column, alternating rows and data bars. Check that colors still work for readers with color-vision differences.

Return to the Power BI hub · Microsoft formatting guidance