Power BI - How to use Conditional Formatting with Background Colors in a Table

Introduction

In Power BI, the visualization and interpretation of data in a table can be improved by using conditional formatting with background colors. This feature dynamically sets the cell colors in a table based on the values it contains. This allows important information to be highlighted so that patterns, trends and outliers can be recognized at a glance. In this tutorial, we will show you how to use conditional formatting with background colors in a table visualization in Power BI.

Data

The data for this tutorial comes from an Excel file. In the following tutorial, we explain how to import data from an Excel file into Power BI:

Power BI - Import Data from Excel file

Introduction In this tutorial, we want to import Data from a Excel file into Power BI. This can be easily done in the Power BI Desktop interface. Data Source Our data source is the Excel file student. The file contains the following data: Power BI Desktop In the following, we

Deep Learning Nerds | The ultimate Learning Platform for AI and Data ScienceData Analyst

We have loaded the data into Power BI without executing any transformations. The data looks as follows:

Create Table Visualization

We have created a table visualization with the columns "name" and "Sum of creditpoints". The column "Sum of credipoints" is sorted in descending order.

Add dynamic Background Color

Now, we want to add a background color to the column "Sum of creditpoints", that will change dynamically based on the column values.