Conditional formatting colors using dax

[omcknac]

Using the dax below, I have created a conditional column where certain %'s turn specified colors if not meeting targets by a certain date. The dax works great but my issue is this... when I go to apply it on the visualization (matrix) it is coloring my individual lines (Level 1) the correct colors but the roll up (averages) of my object descriptions (Level 2) is summarization "First" color at random. How can I get it to apply the correct color to individual lines as well as the averaged lines that the individuals are being rolled up into. The ask is for all to be colored not just values or totals. 

DAX used: 

 Average column I am having issues with: ex data set is the 3 values in the green box are individual lines and the 28% in the purple box is the average of the individual lines... the 28% should be orange based off what I am looking for. The individual lines are colored correct. 

Is there something to change in the dax to fix it or some special secret I should know on how to get the roll up averages to color code the same way the individual lines color code. 

All the thanks for anyone who can help solve my problem!!! 

Olivia

[Anonymous]

Hi @omcknac ,

Thanks to @sevenhills  for the reply, please allow me to provide another insight:

Please try changing the format style to field value and put the measure you created as a field.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[omcknac]

Do I need to change the DAX in order to avoid the summarization option being present?

Edit to reply: I changed the DAX to include MAX:

It didn't change the roll up average turning green instead of orange.

[Anonymous]

Hi @omcknac ,

Please put the color status directly into the visual object and check whether the result it returns is the result you want. If the result presented in the visual object is not the result you expect, please try to modify the expression and then put it into the condition in format. More details about conditional formatting can be found in the documentation: Apply conditional table formatting in Power BI - Power BI | Microsoft Learn.
Also, if you are willing to provide a pbix file with sample data, I will be able to help you solve your problem better.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sevenhills]

Quick check, what is the setting for your rules for background color in conditional formatting?

Is it like this?

[omcknac]

Yes I have it set to values and totals, but because the summarization is there its just choosing the "first" color that appears in the line up.