Conditional Formatting

[hasharma19]

Hi All,

I have prepared a dashboard wherein a small issue noticed during conditinal formatting

The YTD(92.20%) number supposed to be in green as its avboe the target(92.08%) and the gap also be in green.

Surprisingly, the same conditinal formatting i have applied on the table. it is showing correct color coading as green

Can someone pls help me to understand the issue.

[Anonymous]

Hi @hasharma19 ,

Firstly if you are using Card visual I think you can just choose to change the font color manually.

Secondly if you are coloring in a table or matrix, you can create a Measure to adjust the desired background color.

Measure = IF(MAX('Table'[IN])<0.92,"Red","Green")

So you can get what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hasharma19]

  @rit_ty7 @Anonymous @danextian @Below are the measures i have applied on the cards

YTD Perf% measure

Current Month Perf%

Gap from target%

below are the measure applied on the table

background

Fornt

Not able to find any option to upload the PBI File

[rit_ty7]

Hi @hasharma19 , 

To apply the same color logic you used in the conditional formatting of the cell element to the card's background or font, you can use the same example_Color_measure in a similar way. Here's how:

Example Color Measure:

Test_color = 
IF(
    SUM(FACT_SALES_S3_ALL_FILTER[BILLED_QUANTITY]) < 17000000, 
    "#36dfcf", 
    "#ffffff"
)

Steps to Apply This to a Card:

1. Go to the Format Pane of the card visual.
2. Under Effects, find the Background or Font Color option.
3. Click the fx button next to the respective property.
4. In the Conditional Formatting window:
   • Set the Format Style to "Field Value."
   • In the Based on Field dropdown, select the measure Test_color.
5. Apply and close the window.

Now, your card's background or font color will dynamically change based on the logic defined in Test_color.

This approach ensures consistency between the conditional formatting in your matrix or table visuals and the card visual.

Select field value and select the color measurefor text's conditional formatting, go to callout value's color and use the given measure
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Ritesh Kumar,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian]

Hi @hasharma19 

Is the highglighted a dimension or measures?

What is your conditional formatting logic/condition/measure? What is target if added together with YTD Profit in the same visual?