Skip to main content
cancel
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

Reply
sthandiwe
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.

sthandiwe_0-1602231447449.png

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:

sthandiwe_1-1602231584545.png

 

Note:

0=Not Approved=Red
1=Approved=Green

2=Rejected=Yellow

 

2 REPLIES 2
PaulDBrown
Community Champion
Community Champion

@sthandiwe 

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

Condit. format =
SWITCH(TRUE(),

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

Approval Status] = "Approved", 1,

2)

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.






amitchandak
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
"red"
)

 

 

 

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

Helpful resources

Announcements
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.

PBI_Carousel_NL_June

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