Conditional formatting on the axes of a chart

[JoelGR]

Hello,

Actually, when using conditional formatting in charts, I have noticed that it seems to affect the data set as a whole rather than considering the individual values on the axes.

For example, we consider that in a graph there are the following 3 values:

If I make the following conditional format:

It does not show even one value in red when it should show the third record. Instead, if I set > 0 and <= 5, it shows all the records in red because as I mentioned above it looks at the SUM() total of all the data there is in this case for each value.
In the data and table labels it is done as expected:

Is this the way the conditional formatting on the chart axes is designed? Or is there a way to apply it for each value? Instead of taking the SUM for each one. I have tried many ways; fields, measures, no NULL values... but I have not succeeded.
Shouldn't the expected result be per record taking advantage of its relations and groupings and not in its totality for each one? As it works with data labels and tables?

If this is designed this way and putting conditional formatting to the axis refers to the data set of the axis, I would like to suggest the possibility of enabling conditional formatting by value in charts. This would allow highlighting specific ranges of values on the Y-axis for each label on the X-axis independently.
I hope I have provided useful information.

I appreciate your attention to this query and suggestion, and look forward to your response.

[JoelGR]

So I understand that this is normal and that for the moment it is not possible to do it on a chart.

Thank you,

[Anonymous · Accepted solution]

Hi @JoelGR ,

This is normal because Power BI does an aggregation of the Y-axis values based on the X-axis values, if you want to apply it to every value, try to use table visual or matrix visual.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.