Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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 logo


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 logo


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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.