Conditional Formatting Issues

[Anonymous]

Hi everyone,

I am trying to get the data colors I have to stay the same when I refresh the data in the desktop application.  When I refresh the data it switches the colors I have (Green, Red, Blue) and it will automatically switch the colors to something completley different (possibly the default colors).  I am using the Calendar Visual by MAQ Software and there isn't an option for conditional formatting in the data colors section.  Is there a way in the Power Query editor that I can get around this by putting in the color hex coding somewhere?  Or is there a way to stop Power BI from changing the data colors from what I set them at?  Thanks!  

[parry2k]

@Anonymous if it is a custom visual, it will make sense to ask the developer. I know custom visuals doesn't support conditional formatting (as you can see)

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Hi @parry2k,

Do you know why Power BI desktop would change the data colors each time I refresh the data and how I can get it to stop doing that?  Or if there is a way using Power Query to get around this issue? Thanks!

[v-chenwuz-msft]

Hi @Anonymous ,

The color is depend on legend field. As far as I know, the colour does not change if the field does not change.

Best Regards

Community Support Team _ chenwu zhu

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