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.
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
I'm after the same thing, any news on this?
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.
@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 🙂
Hey Microsoft, very basic formatting feature needed... one year after release conditional formatting on Line Graphs still needed.
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.
Thanks Dbrothers, I can confirm that this issue is fixed in (at least) the current version and now works as expected for me 👍
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.