No Conditional Formatting Drop Down?

[ShrimpSurf]

For some reason my conditional formatting drop-down disappeared? 

[v-jayw-msft · Accepted solution]

Hi @ShrimpSurf ,

Select the visual and you could manage the conditional formatting for Data label, Category label and Background under Format pane.

Best Regards,

Jay

[naveenmechu]

Hi,

 Not clear what you are trying to achive, Properties vary according to visual type. If you use table or Matrix visual, it will come.

Please accept it as solution, if you got answer of your query.

Thanks 

Naveen Mechu 

[Pragati11]

HI @ShrimpSurf ,

What visual is this where you are trying to find conditional formatting option?

Thanks,

Pragati

[ShrimpSurf]

The card.

[Pragati11]

Hi @ShrimpSurf ,

Card visual doesn't give you conditional formatting option.

You can try other visuals like table or matrix visual.

Thanks,

Pragati

[ShrimpSurf]

Are you able to format so that it is red for negative and black for positive?

[naveenmechu]

Hi,

Follow below steps--

1. Create measure as below

color = SWITCH(

TRUE(),

[Total hours] >=0,"Green",

"Red"

)

2. Select fx in front of color under data label as below

3. Select format style as field value and under field select your measure.

Hope you got answer.

Thanks 

Naveen Mechu