cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShrimpSurf
Helper II
Helper II

No Conditional Formatting Drop Down?

For some reason my conditional formatting drop-down disappeared? 

Screen Shot 2022-01-14 at 10.05.06 AM.jpg

 

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @ShrimpSurf ,

 

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

1.PNG2.PNG

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

7 REPLIES 7
v-jayw-msft
Community Support
Community Support

Hi @ShrimpSurf ,

 

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

1.PNG2.PNG

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
naveenmechu
Helper I
Helper I

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.

 

naveenmechu_0-1642182351220.png

 

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

 

 

Thanks 

Naveen Mechu 

Pragati11
Super User
Super User

HI @ShrimpSurf ,

 

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

 

Thanks,

Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

The card.

Hi @ShrimpSurf ,

 

Card visual doesn't give you conditional formatting option.

You can try other visuals like table or matrix visual.

 

Thanks,

Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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

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
naveenmechu_0-1642220901978.png

 

 

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

naveenmechu_1-1642221025673.png

Hope you got answer.

 

Thanks 

Naveen Mechu

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!