No Conditional Formatting Drop Down?

[ShrimpSurf]

For some reason my conditional formatting drop-down disappeared? 

[Anonymous · 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

[mohammadyousaf]

this is ok for the slicer background but there is no option of conditional formatting for Slicer Values. 

For example, my dropdown slicer has 10 product types, out of which 7 products type were sold last day... I want to highlight values color or background or make it bold or italic to let my users know what productions were sold last day so he/she can directly go to those products instead of checking all 10 products one by one to know the sales. 

How do we achieve this on drop down slicer? Any workaround?

Here basically I am trying to conditional format the values but no option availabe. 

[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