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

Ameeruddin Mohammed

ETL (Abintio) developer at IBM
linkedin profile url

I come from a background in Marketing and Analytics and when I developed an interest in Machine Learning algorithms, I did multiple in-class courses from reputed institutions though I got good... Read More

Relevant Projects

Learn to Build Generative Models Using PyTorch Autoencoders
In this deep learning project, you will learn how to build a Generative Model using Autoencoders in PyTorch

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.

Predictive Analytics Project for Working Capital Optimization
In this Predictive Analytics Project, you will build a model to accurately forecast the timing of customer and supplier payments for optimizing working capital.

Learn to Build a Siamese Neural Network for Image Similarity
In this Deep Learning Project, you will learn how to build a siamese neural network with Keras and Tensorflow for Image Similarity.

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.

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

Isolation Forest Model and LOF for Anomaly Detection in Python
Credit Card Fraud Detection Project - Build an Isolation Forest Model and Local Outlier Factor (LOF) in Python to identify fraudulent credit card transactions.

Learn How to Build PyTorch Neural Networks from Scratch
In this deep learning project, you will learn how to build PyTorch neural networks from scratch.

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

Walmart Sales Forecasting Data Science Project
Data Science Project in R-Predict the sales for each department using historical markdown data from the Walmart dataset containing data of 45 Walmart stores.