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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Barendnu
Advocate III
Advocate III

Barchart conditional formatting of the labels using "fx" button

Hi all,

 

In a graph, I'd like to show values below fifty in red, and values above fifty in green. This is a simplified version of our actual data setup. This works perfectly when I use a graph without a legend:

 

Good-settings.PNGGood.PNG

 

However, when I add a legend, the "fx" option at data colors disappears. This is expected.

Bad-settings.PNG

 

So I thought, instead of using data colors, I'd use the "fx" button on data labels color, as introduced in July 2021. However, this doesn't give the desired results. The labels do not color differently for "below 50" and "above 50" values:

Bad.PNG

 

 

Am I missing something? Am I doing something wrong? Any help would be greatly appreciated!

The .pbix can be found here: https://we.tl/t-QeI1QCKxHX

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

Hi @Barendnu ,

I can reproduce your question, and I noticed that you have created a support ticket for it. The related support person has reported the problem internally. I will update you soon if there is any progress later.

yingyinr_0-1629789879514.png

Best Regards

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

View solution in original post

9 REPLIES 9
v-yiruan-msft
Community Support
Community Support

Hi @Barendnu ,

I can reproduce your question, and I noticed that you have created a support ticket for it. The related support person has reported the problem internally. I will update you soon if there is any progress later.

yingyinr_0-1629789879514.png

Best Regards

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

Thank you very much! We'll keep an eye on the mentioned support ticket issue 🙂

mussaenda
Super User
Super User

Hi @Barendnu,

 

There is Legend on your chart.

 and then there is conditional formatting.

 

So which one Power BI should follow?

 

Solutions I am thinking:

1. Have a slicer of male and female.

2. have two charts, one for male. one for female.

 

Hope this helps.

The desired result is that labels are coloured matching the value that you actually see on screen:

Barendnu_1-1629381256459.png

 

So "20" should be red, and the others green. Creating seperate slicers or charts is not an option I'm affraid. The sample I've given (red below 50, green above) is simplified. Actually, we want to use these colouring to show if results are significantly different or not, and we are looking for a way to visualise the result of this measure (true/false) in the barchart.

@Barendnu ,

 

then put the gender on x axis to group the yes or no. instead of legend.

It will hold the conditional formatting that you want.

 

hope this helps.

Thanks for the suggestion, mussaenda! Unfortunately, we already use the X-axis to visualise the different subjects in this graph:

 

graph.png

 

As said, we want to use these colouring to show if results are significantly different or not, and we are looking for a way to visualise the result of this measure (true/false) in the barchart.

 

amitchandak
Super User
Super User

@Barendnu , I checked this, I think it works on the overall number, not the line number. 55 Is Avg. you can check.

 

Unless documentation says, it should work at line level, this might be by design

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Thanks for the reply! Do you have a suggestion if/how I could verify this? I was unable to find more documentation than the mentioned in the Power BI July 2021 Feature Summary.

 

I'm in doubt to submit a bug report, but am not sure if it is actually a bug 🙂

I took the liberty to report this as an issue. Let's see what comes out of it!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.