top of page

17th century watercolours

The report is inspired by a specific post and focuses on replicating similar results in Power BI using a simple bar chart approach. It features a straightforward model with all data in one table, organized into two sections of unique color groups, each containing five types of colors with associated value columns that serve as color codes. After finalizing the report's layout, the page was adjusted to ensure the visuals fit perfectly without the need for scrolling.

Design Approach

Dataset Details :


Dataset details are provided on https://www.c82.net/work/?id=390 . From the link,"the data is available at Colour names and digital colour values available as a Google Sheet or as JSON files for pure colours and their mixtures."


Design Approach:

The report is purely inspired by this post -  https://www.c82.net/work/?id=390 

The challenge was achieving the same or similar results in Power BI. If I had more time or patience, we could accomplish many more things with this palette. However, I opted for a simple approach by using a bar chart. Sometimes, simplicity is better than complicating things.


It's a straightforward model. All the data is in one table.

What does data look like:

  1. I have two sections that describe groups of colours.

  2. Each unique colour group has five types of colours.

  3. Each colour includes a value column that serves as a colour code, which can be utilised in Power BI.

  4. I can use the formatting style below to apply the colour code in various visuals.



Once I understood how my report would look, I created a page with a title and a visual. After assembling everything, I adjusted the page size to ensure the entire visual fit on one page without scrolling vertically or horizontally.

bottom of page