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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Background colour formatting.

Hi All

I have a dashboard where I need the background of a cell to reflect a certain colour depending on the contents of it. The rules are as follows.


It works well mostly. But there are some times when it reflects the wrong colour as shown below, the top right "Not Approved" should be in red, not yellow:




0=Not Approved=Red



Community Champion
Community Champion


Let's assume you are using a measure for the Approval Status. You can create a measure for the conditional formatting like:

Condit. format =

[Approval Status] = "Not Approved", 0,

Approval Status] = "Approved", 1,


Now use this measure in the conditional formatting interface -select the measure in the "based on the field" option- 

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Super User
Super User

@sthandiwe , need to check data for that. Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.


Can you create a color measure directly on values like in the given example and use that with the "Field Value" option(in place od rule


color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions




Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors