how to do shading to text style in power bi table

This recipe helps you to do shading to text style in power bi table

Recipe Objective - How to do shading to text style in power bi table?

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

Task - Apply Font color conditional formatting on Sales column.

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.

Build a Multi Touch Attribution Model in Python with Source Code

Step 4 - Apply conditional formatting on 'Table' visual

Select table -> Format -> Conditional formatting -> Select the 'Sales' column -> Turn on Font Color.

By default, power bi has a blue color theme. To change color, go to Advanced controls -> Change minimum and maximum color.

In this way, we can do shading to text style on the table in the power bi report.

What Users are saying..

profile image

Abhinav Agarwal

Graduate Student at Northwestern University
linkedin profile url

I come from Northwestern University, which is ranked 9th in the US. Although the high-quality academics at school taught me all the basics I needed, obtaining practical experience was a challenge.... Read More

Relevant Projects

Word2Vec and FastText Word Embedding with Gensim in Python
In this NLP Project, you will learn how to use the popular topic modelling library Gensim for implementing two state-of-the-art word embedding methods Word2Vec and FastText models.

Deep Learning Project for Text Detection in Images using Python
CV2 Text Detection Code for Images using Python -Build a CRNN deep learning model to predict the single-line text in a given image.

Multilabel Classification Project for Predicting Shipment Modes
Multilabel Classification Project to build a machine learning model that predicts the appropriate mode of transport for each shipment, using a transport dataset with 2000 unique products. The project explores and compares four different approaches to multilabel classification, including naive independent models, classifier chains, natively multilabel models, and multilabel to multiclass approaches.

Build a Graph Based Recommendation System in Python -Part 1
Python Recommender Systems Project - Learn to build a graph based recommendation system in eCommerce to recommend products.

MLOps Project to Deploy Resume Parser Model on Paperspace
In this MLOps project, you will learn how to deploy a Resume Parser Streamlit Application on Paperspace Private Cloud.

Recommender System Machine Learning Project for Beginners-4
Collaborative Filtering Recommender System Project - Comparison of different model based and memory based methods to build recommendation system using collaborative filtering.

Build ARCH and GARCH Models in Time Series using Python
In this Project we will build an ARCH and a GARCH model using Python

Build a Autoregressive and Moving Average Time Series Model
In this time series project, you will learn to build Autoregressive and Moving Average Time Series Models to forecast future readings, optimize performance, and harness the power of predictive analytics for sensor data.

Recommender System Machine Learning Project for Beginners-1
Recommender System Machine Learning Project for Beginners - Learn how to design, implement and train a rule-based recommender system in Python

Abstractive Text Summarization using Transformers-BART Model
Deep Learning Project to implement an Abstractive Text Summarizer using Google's Transformers-BART Model to generate news article headlines.