ArcGIS for Power BI is not maintaining my settings

Question

I am trying to create a map using ArcGIS for Power BI for a client. I have the data entered via Latitude and Longitude and inserted the variable containing the district name into the color box in Build Visuals tab. That generated a map of points, but I noticed that 9 of the districts had different colors but the other (20ish) districts were all grey. When I looked at symbology, I saw that the grey districts were all combined into a classification called "Other".

I moved each of these districts out of other and gave them different colors. This displayed the districts as I wanted. I then clicked on several features on the report (table, slicers, etc.) and the points on the map eventually reverted back to the 9 colors and a grey "Other" display. I corrected it again, but it eventually reverted back to the default.

I also noticed that when I looked at the Location Type (under the Visual tab), the selected country was "World", Since my points (including the Lat/Long) all fell within the USA, I changed the country to "United States". Doing so immediately reverted the color symbology back to the 10 districts and an "Other" and the country was immediately changed back to "World" (the program did this).

I want my classifications to remain as I set them and not revert back to the defaults; how do I fix this issue?

ZacharyGerber · Answer

Hey there Robert,

Did you ever figure out a solution to this issue? I am facing the same problem over here and am scratching my head trying to figure out what would work.

In my case, I've got the map fully configured how I want it and will not be updating the format settings further. However, I configured the choropleth map using a Measure Switch in the "Color" well, so that readers can select which Race they wish to be classified on the map.

In this case, looking at Foster Care Entry Rates by Race per State in the U.S. So, when a user selects a different race from the Switch drop-down, the map will then classify the data and color each state polygon based on the values for the selected race. Whenever I select a new race from the drop-down, it resets the layer settings (such as color ramp, labelling settings, etc).