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

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

Reply
mw456
Regular Visitor

Conditional Formatting in Table Visualization

I'm new to Power BI and am having trouble using conditional formatting on a table visualization. I would like something like the followng:

 

Month

Budget

Spend

Jan

1000

950

Feb

1000

1500

Mar

1000

975

 

Basically, if the value of Spend exceeds the Budget amount, the text should be displayed in red. The existing Conditional Formatting feature allows you to format text based on a value specified at design time. I would like to compare to another field in the data set. This is trivial in Excel. Is this supported in Power BI? 

 

TIA

1 ACCEPTED SOLUTION
Phil_Seamark
Microsoft Employee
Microsoft Employee

I don't think any of the base visuals, or those in the Gallery have that option just yet.  Suggest it as an idea and I'll vote for it! 🙂


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @mw456,

 

It is not possible to do it currently. You can vote the idea here and add your comments there to improve Power BI and make this feature coming sooner.Smiley Happy

 

Regards

Phil_Seamark
Microsoft Employee
Microsoft Employee

I don't think any of the base visuals, or those in the Gallery have that option just yet.  Suggest it as an idea and I'll vote for it! 🙂


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.