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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.