How can we color the information bars in power bi

This recipe helps you to color the information bars in power bi

Recipe Objective - How can we color the information bars in power bi?

We apply conditional formatting on the table so that users can easily get insights from the data. Information bar is one of the ways to apply conditional formatting.

Task - Apply Information bar conditional formatting on Profit column.

Explore Interesting IoT Project Ideas for Practice

Step 1 - Open power bi report

Step 2 - Add 'Table' visual in the power bi report.

To add 'Table,' go to Visualization pane -> Drag and drop 'Table' visual in power bi report.

Step 3 - Add fields into the 'Table' visual.

Put Category, Sub-category, Profit, Sales in Values field.

Step 4 - Apply conditional formatting on 'Table' visual

Select table -> Format -> Conditional formatting -> Select the 'Sales' column -> Turn on Data bar.

By default, power bi has a blue color theme. To change color, go to Advanced controls -> Change color for Positive bars and Negative bars.

In this way, we can color the information bars in the power bi report.

What Users are saying..

profile image

Ray han

Tech Leader | Stanford / Yale University
linkedin profile url

I think that they are fantastic. I attended Yale and Stanford and have worked at Honeywell,Oracle, and Arthur Andersen(Accenture) in the US. I have taken Big Data and Hadoop,NoSQL, Spark, Hadoop... Read More

Relevant Projects

Image Classification Model using Transfer Learning in PyTorch
In this PyTorch Project, you will build an image classification model in PyTorch using the ResNet pre-trained model.

Census Income Data Set Project-Predict Adult Census Income
Use the Adult Income dataset to predict whether income exceeds 50K yr based oncensus data.

Forecasting Business KPI's with Tensorflow and Python
In this machine learning project, you will use the video clip of an IPL match played between CSK and RCB to forecast key performance indicators like the number of appearances of a brand logo, the frames, and the shortest and longest area percentage in the video.

Insurance Pricing Forecast Using XGBoost Regressor
In this project, we are going to talk about insurance forecast by using linear and xgboost regression techniques.

Multi-Class Text Classification with Deep Learning using BERT
In this deep learning project, you will implement one of the most popular state of the art Transformer models, BERT for Multi-Class Text Classification

Text Classification with Transformers-RoBERTa and XLNet Model
In this machine learning project, you will learn how to load, fine tune and evaluate various transformer models for text classification tasks.

Locality Sensitive Hashing Python Code for Look-Alike Modelling
In this deep learning project, you will find similar images (lookalikes) using deep learning and locality sensitive hashing to find customers who are most likely to click on an ad.

Build an Image Classifier for Plant Species Identification
In this machine learning project, we will use binary leaf images and extracted features, including shape, margin, and texture to accurately identify plant species using different benchmark classification techniques.

MLOps Project on GCP using Kubeflow for Model Deployment
MLOps using Kubeflow on GCP - Build and deploy a deep learning model on Google Cloud Platform using Kubeflow pipelines in Python

Build a Face Recognition System in Python using FaceNet
In this deep learning project, you will build your own face recognition system in Python using OpenCV and FaceNet by extracting features from an image of a person's face.