Forum Discussion
Maintain Colors after data refresh
gcam032 , You can try to use conditional formatting, You will be able force that line and pie too
Switch( True(),
max(Customer[Name]) = "Abc" , "Green,"
max(Customer[Name]) = "Def" , "Gray,"
// Add other
"blue"
)
refer my video on the same
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
Thanks. The solution I need is slightly different. Using your video as an example, you have Brand 1-13. Let's say you refresh and now you have Brand 20-33 (i.e. the brands are different names than before). I need PBI to always use the correct colour order as defined by the theme - but what happens, is that it gives the new brands colours that are not defined in the theme or at least it doesn't start at the first colour.
Any ideas? I can't define a brand (or other field) by name as they change depending on the data coming into the template.
hi , did you find a solution? i have the same problem
