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

Savvy Sahai

Data Science Intern, Capgemini
linkedin profile url

As a student looking to break into the field of data engineering and data science, one can get really confused as to which path to take. Very few ways to do it are Google, YouTube, etc. I was one of... Read More

Relevant Projects

Linear Regression Model Project in Python for Beginners Part 2
Machine Learning Linear Regression Project for Beginners in Python to Build a Multiple Linear Regression Model on Soccer Player Dataset.

FEAST Feature Store Example for Scaling Machine Learning
FEAST Feature Store Example- Learn to use FEAST Feature Store to manage, store, and discover features for customer churn prediction machine learning project.

Learn to Build a Neural network from Scratch using NumPy
In this deep learning project, you will learn to build a neural network from scratch using NumPy

Learn How to Build a Logistic Regression Model in PyTorch
In this Machine Learning Project, you will learn how to build a simple logistic regression model in PyTorch for customer churn prediction.

Model Deployment on GCP using Streamlit for Resume Parsing
Perform model deployment on GCP for resume parsing model using Streamlit App.

Time Series Project to Build a Multiple Linear Regression Model
Learn to build a Multiple linear regression model in Python on Time Series Data

Avocado Machine Learning Project Python for Price Prediction
In this ML Project, you will use the Avocado dataset to build a machine learning model to predict the average price of avocado which is continuous in nature based on region and varieties of avocado.

Demand prediction of driver availability using multistep time series analysis
In this supervised learning machine learning project, you will predict the availability of a driver in a specific area by using multi step time series analysis.

Skip Gram Model Python Implementation for Word Embeddings
Skip-Gram Model word2vec Example -Learn how to implement the skip gram algorithm in NLP for word embeddings on a set of documents.

NLP and Deep Learning For Fake News Classification in Python
In this project you will use Python to implement various machine learning methods( RNN, LSTM, GRU) for fake news classification.