Conditional formatting for Data label colors at line level

[Barendnu]

When using conditional formatting for data labels, as introduced in July 2021, the overall number is used for the calculation, instead of the line number average.

Using "data colors > default color > fx" gives the expected behavior. Bars with an average value above 50 are green, others red:

However, when choosing "data labels > color > fx", the same setup results in all data labels shown in a green font:

Expected behavior is that a bar with an average value below 50 shows a data label with a red font color.

Thus, using the context specific calculated value for that line/bar.

[v-yingjl]

Hi @Barendnu ,

Have reproduced it in my side and submited internal for waiting to confirm this issue(ICM: 257982572). Would update here as soon as possible if there is any progress.

Best Regards,
Community Support Team _ Yingjie Li

[jeseng]

I'm after the same thing, any news on this?

[Will_1]

I too am awaiting a solve for this. For those of us that work with patient Health Data this is a tremendous asset when statistical de-identification is not possible due to sample size. 

[Barendnu]

@v-yingjl : I'm curious if there's any update about this? We want to use this to show the result of a significance test, so that's why this would be really welcome to have 🙂

[Anonymous]

Hey Microsoft, very basic formatting feature needed... one year after release conditional formatting on Line Graphs still needed.

[Dbrothers]

I do not know if this will help anyone, but you might try doing a "reset to defaults" on the data labels and then go through setting up again.  What I have found is that if a conditional formatting for value color is chosen and set, and then a field gets added(say to the Y Axis to show differing categories like yes/no above), then new edits to the datalabel color will not take effect because a previous setting is still there it would seem(artifact setting?).

I found this while trying to make a simple example of an issue I am still having with datalabels conditional formatting of color using a measure value.  This however did not fix my issue particular issue, but I thought at first I had replicated my bug of where it was having different text color value than the actual measure value.

[Barendnu]

Thanks Dbrothers, I can confirm that this issue is fixed in (at least) the current version and now works as expected for me 👍