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
aalfa
Frequent Visitor

Conditional Format Bar Chart

Hello,

 

I am trying to create a very simple conditional format on a bar chart where if the first bar is less than the second bar it colors the first bar red. To be more exact, one is Actual % Complete and the second is Expected % Complete. For some reason, I cannot add either value to the "Color Saturation" or even the "Legend" fields. Both fields are a calculated column, not a measure. Please let me know what I may be missing.

25% should be red.25% should be red.

Thank you,

Alex

 

1 REPLY 1
v-huizhn-msft
Employee
Employee

Hi @aalfa,

After research, we are unable to set the customer colour for your scenario. We can set the different categories colour suing data colors. For single bar, you can customize the colors used in the color scale using Minimum and Maximum or Diverging color scales. You can create an idea here and also vote this request thread.

Best Regards,
Angelia

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.