Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
QuasemS
Frequent Visitor

Color based on number value

Hi,

 

I am trying to create a table like this:

 

tablecolor.PNG

 

But when I create a table, I can't seem to get the color to show based on the value. Basically I want the same thing which goes from 0-100 and red to green. I couldn't find any thresholds where I can set colors or anything in the table visual.

 

Does anyone know how to achieve this?

 

Thanks!

1 ACCEPTED SOLUTION

That screnshot has actually been taken from Power BI, and I figured out how to do it. It's called 'conditional formatting' and can be found in the drop down menu for 'fields'

View solution in original post

3 REPLIES 3
Totte67
Frequent Visitor

I have also look´t on this and what I have seen,
you can not get that in Power BI yet, like you have in Ecxel,
but what I read it will come sone,
I hope:-)
You have a Visiual that can get you a card with color "Card with States by SQLBI"

 

Best regards

Totte67

That screnshot has actually been taken from Power BI, and I figured out how to do it. It's called 'conditional formatting' and can be found in the drop down menu for 'fields'

Thanks, then I also got the solution 🙂
It look´s like Excel but now when I looked at it again I saw it was in Power BI.

 

Best regards

Totte67

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors