Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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!
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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!
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.
| User | Count |
|---|---|
| 56 | |
| 40 | |
| 38 | |
| 21 | |
| 21 |
| User | Count |
|---|---|
| 140 | |
| 102 | |
| 64 | |
| 36 | |
| 35 |