NewDataLabs

Tableau - Business Intelligence Tools

  • Solutions
    • ETL
      • Tableau Prep
      • Airflow
      • Power Query
      • Microsoft Integration Services
      • Fivetran
    • Data warehouses
      • Snowflake
      • Google Big QUERY
      • Microsoft SQL Server
      • PostgreSQL
      • Web analytics
      • Amplitude
    • Business Intelligence
      • Tableau
        • What is Tableau?
        • How to implement Tableau properly?
        • Interactive management dashboard
        • Tableau price list
        • Products of Tableau
          • – Tableau Desktop
          • – Tableau Server
          • – Tableau Prep
          • – Tableau Online
        • Tableau Audit
        • Tableau Day
      • Power BI
  • Services
    • Tableau workshops on your data – Proof of Concept
    • Preparation of data – ETL
    • Reporting and data visualization
    • Migration services
    • Tableau training courses
    • Embedded Analytics
  • Salesforce
    • Salesforce CRM
      • Customer relationship management
      • Sale
        • Sales opportunity management
      • Business Intelligence analysis
      • Salesforce Manufacturing Cloud
      • Salesforce Service Cloud
      • Salesforce Marketing Cloud
    • Services
      • Proof of Concept
      • CRM workshops
      • Implementation of CRM
      • Post-implementation support
      • Data migration
      • Salesforce training
      • CRM consultancy
      • Salesforce integrations
    • Tableau + Salesforce
  • About Us
  • Customers
    • Our Customers
    • Customer stories
      • Totalizator Sportowy Sp. z o.o.
      • Snieżka S.A.
      • Werner Kenkel Sp. z o.o.
      • DOZ S.A.
  • Events
    • Webinars >
      • Salesforce
      • Tableau
      • Power BI
    • Tableau Training Courses >
      • New Data Model
      • Tableau online course
      • Tableau training courses
    • Power BI Training Course
  • Blog
  • Download Tableau
    • Tableau Desktop – Trial
    • Tableau Server – Trial
    • Tableau Prep – Trial
    • Tableau Reader
  • Contact
EN / PL

Colour Contrast Calculator in Power BI

2024-01-02

The number of UX enthusiasts who place great emphasis on the User Experience is rapidly growing. One of the factors that affect the way the report is perceived is the colour palette used in it. Today we are going to discuss how the Colour Contrast Calculator in Power BI can help you in your work.

Colour palette – where to start

The process of selecting colours should start with learning about the brand colours used by the company for which a report is going to be prepared. If there are no brand colours, choose the palette you would like to use. The colours selected are primarily intended to direct the user’s attention in such a way that they can easily access the information needed. Colours are undoubtedly the key element of the visualization; however, it is reasonable to be moderate and use colours where appropriate only. The colour palette of the report should not interfere with the analytical process; therefore it is vitally important to combine the selected colours in a well-thought manner.

Colour Contrast Calculator in Power BI

The question arises as to how to properly combine colours? For this purpose, it is worth using a variety of available tools, such as the colour contrast calculator which can be created directly in Power BI. This tool allows you to see whether the contrast between the colours you wish to use is sufficient. Below is the example contrast calculated in Power BI.

The calculator is nothing more than a report created in Power BI based on the dataset generated in Power Query. The dataset consists of columns with R (red), G (green) and B (blue), which are used as a basis to create colours from the RGB palette. In addition, there is a colour column in a hexadecimal format – a HEX code. With such a set of data you can choose the desired colours and calculate their contrast ratio.

Colour contrast and WCAG standards

The colour contrast ratio is calculated in accordance with the guidelines of the WCAG standard. They stipulate that:

· The contrast between the text and the background should not be bigger than 4.5

· The contrast between non-text content (e.g., a chart) and the background should not be bigger than 3.

This calculator is fast and simple to use. All you need to do is to select two colours you wish to combine and enter them in the fields “Select Colour 1” and “Select Colour 2” as a HEX code. Below you will see the details of your selection in HEX and RGB formats. On the right, you will see the analysis of the contrast between the two colours. Depending on the choices made, you can receive the following feedback:

  • The contrast is appropriate both for text and non-text content

  • The contrast is insufficient, and your combination can be used only for decorative elements

  • For text, the contrast can be used for large or bold fonts only, and it is sufficient for non-text content

When choosing two colours, you should always aim for getting a ratio consistent with the aforementioned guidelines. The feedback should state that the contrast is sufficient and suggest the combinations, in which this configuration can be applied. Try to avoid combining colours when the feedback says the contrast is insufficient – it will make your report unclear. Let’s imagine that with the use of conditional formatting, the colours of the background and font are combined as shown in the below table.

The contrast between these colours is too small. As a result, the user may draw incorrect conclusions or will spend too much time trying to read the figures in the table. Using the colour contrast calculator will help you avoid these errors, as you will know at the report design stage, what colour combinations should not be used.

Colour Contrast Calculator – the advantages

Using colours in different parts of your visualizations will help present a more impressive story that will quickly attract your audience. The right choice of colours will ensure your reports:

– are well-balanced

– reduce the time needed to analyze the data

– help you quickly and easily understand the message

The colour contrast calculator is a handy tool for those who create reports, as it gives tips on how to correctly use colours. It will certainly help prepare reports which are clearer and more easily understandable for end users.

Below is a link to the contrast calculator created in Power BI. I encourage you to use it.* LINK: https://app.powerbi.com/groups/e2635f2b-81c1-4386-a496-6ee72ebf486b/reports/60f46867-6fcf-4bfe-acc8-438066c48da3/ReportSectiona5504ee40a2e0ce509be?redirectedFromSignup=1

* The report downloads colours slowly due to the large number of possible combinations ** Source of inspiration https://www.workout-wednesday.com/

Joanna Korbecka Power BI Consultant

Webinars
> Amplitude Webinars
> Tableau Webinars
> Power BI Webinars

Tableau training courses
Power BI online course
ETL
> Tableau Prep
> Airflow
> Power Query
> Microsoft Integration Services
Data warehouses
> Snowflake
> Google BigQuery
> Microsoft SQL Server
> PostgreSQL
Business intelligence
> Tableau
> Salesforce
> Power BI
Web analytics
> Amplitude
Salesforce
> Customer relationship management
> Sale
> Sales opportunity management
> Analysis Business Intelligence
> Salesforce Manufacturing Cloud
> Salesforce Service Cloud
> Salesforce Marketing Cloud
Contact

contact@newdatalabs.com
contact@newdatalabs.com


601797783
+48 781 648 194


Adres
Correspondence address:
al. T. Boy’a – Żeleńskiego 26,
51-160 Wrocław

Copyright © 2025

Manage Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}
The newdatalabs.com/en website uses cookies. We use information saved using cookies and similar technologies, including for advertising and statistical purposes and to adapt our website to the individual needs of users. By continuing to use the site, you agree to the terms.Close