How to apply conditional formatting TEXT only in card ?

[Delion]

Hi

how to apply conditional formatting TEXT only  in card ?

Thank

[Icey · Accepted solution]

Hi @Delion ,

Try this:

Measure = IF(SUM('Table'[Column2])>=3,"Red","Black")

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[Delion]

Thank @Icey 

I have further question

How to make this color coding dynamic ?

Example :

Jan sales < 10% color Red

Feb sales < 20% color Red

March sales < 30% color Red

[Icey]

Hi @Delion ,

How are your card visualizations created? One month sales for one card?

Best Regards,

Icey

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

[Delion]

@Icey 

no

1 card for all month sales

[Icey]

Hi @Delion ,

How about something like this:

Measure =
VAR All_ =
    CALCULATE ( SUM ( 'Table'[Sales] ), ALL ( 'Table'[Month] ) )
VAR Jan_ =
    CALCULATE ( SUM ( 'Table'[Sales] ), 'Table'[Month] = 1 )
VAR Feb_ =
    CALCULATE ( SUM ( 'Table'[Sales] ), 'Table'[Month] = 2 )
VAR Mar_ =
    CALCULATE ( SUM ( 'Table'[Sales] ), 'Table'[Month] = 3 )
RETURN
    IF (
        Jan_ / All_ < 0.1
            || Feb_ / All_ < 0.2
            || Mar_ / All_ < 0.3,
        "Red",
        "Black"
    )

Best Regards,

Icey

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

[Delion]

@amitchandak 

I mean the number will change the color base on threshold

[amitchandak]

@Delion , Create a color measure and use that in conditional formatting using field value option

color = if([meausre] <[threshold] ,"red", "green")

Refer to the link I have given last update for steps. Or part of this video have that -https://www.youtube.com/watch?v=veCtfP8IhbI

[amitchandak]

@Delion , the text of the card mean on title?

refer: Color Field - Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values