Map Conditional Formatting colors change layer order??

[JamesA]

Hi - I have a bubble map that uses a magnitude datapoint for size and 6 rules in Conditional Formatting for color. I'm looking for an explanation on why the order of the conditional formatting colors on the map change after the file is opened when a calculation or save is done. Notice the orange color layer in the image below. This orange color is in the middle of the conditional formatting range (i.e. there are rules above and below.) It stands out best when the file is first opened (after the data is first imported) but then gets buried after a save or an update/calculation.

Changing the order of the rule associated with orange in the conditional formatting rules does not fix the issue.  I cannot seem to control the order of the colors on the map.  

Any suggestions for fixes to this?

[v-yadongf-msft]

Hi @JamesA ,

I can't reproduce your problem, it works fine on my computer.

I want to confirm two things with you:

1.Whether your Desktop is the latest version, if not , please install the latest version and try again.

2.Have you tried using the SWITCH function, which forces the color to map like below shown:

Column = SWITCH(
    TRUE(),
    'Table'[Value] = "aa","red",
    'Table'[Value] = "bb","yellow",
    'Table'[Value] = "cc","green")

Best regards,

Yadong Fang

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

[JamesA]

Yadong - Thank you for your reply.  Yes, I do have the latest desktop version. 

I had not tried to add a Switch column.  However, that does not solve the issue. Forcing a color with Switch I believe gives me two options:   Use the Switch column data in the Legend field, or use it in conditional formatting with Field Value. 

With the Switch data in the Legend field of Map Visualization draws pie chart symbols on the locations which is not what I wanted.  (The data is by US postal code -Zip code- so there are multiple values (of different magnitudes) per Zip.)  The image in my original post shows dots of different magnitudes drawn on top of each other.  And using the conditional formatting option seems to draw primarily the first color I.E. the lowest value within the dataset (regardless of magnitude) is drawn as the top layer, obscuring lower layers. 

This issue is less about setting or forcing colors and more about how to control which data layers are show on top on a map.