Barendnu's avatar
Barendnu
Icon for Advocate III rankAdvocate III
5 years ago
Status:
New

Conditional formatting for Data label colors at line level

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.

7 Comments

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support

    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?

  • Anonymous's avatar
    Anonymous
    Not applicable

    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 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable

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

  • Dbrothers's avatar
    Dbrothers
    Regular Visitor

    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 👍