Power BI provides many different ways to customise your dashboards and reports. Acclario’s BI Consultant @Andy Lee details steps to make your Power BI visualisations more compelling, interesting, and customised to your needs.

The following tips are provided to show how to highlight minimum and maximum values for bar and column charts. This helps convey difference in scale while keeping to a specific colour set.

Before and After


  1. Select the bar graph visualisation in your report
  2. Go to the Visualisations pane
  3. Expand the “Data colours” option
  4. Click the “fx” button
  5. Using the Color Scale format, select the colours for minimum and maximum
  6. Click “OK”

Find out more about our Data and Analytics services.