Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Conditional formatting colors using dax

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 app...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

     

    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.