Forum Discussion

sthandiwe's avatar
sthandiwe
Frequent Visitor
5 years ago

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:

 

Note:

0=Not Approved=Red
1=Approved=Green

2=Rejected=Yellow

 

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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.

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    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-