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

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register 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
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

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.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.