Conditional Formatting in Maps

[derektd]

I have only seen some really old posts on conditional formatting on map bubbles.

I have a column that tells me if a date falls in the last week and will return a "1" for that line item.

I would like to conditionally format a bubble on a map with total red if the "lastweek" column is blank and greeen if the column contains a "1".  

Right now it splits the color of the bubble becuase some locations have ites outside the date range "blank" and inside the date range "1".

[deldersveld]

Create a measure along the lines of:
Color measure=

SWITCH(TRUE(),
    ISBLANK(LASTNONBLANK('Table'[lastweek],1)), "red",
    LASTNONBLANK('Table'[lastweek],1) = 1, "green"
)

Once you have the measure available, go to Format / Data Colors / Advanced Controls and select the new measure instead of the column.

[derektd]

This worked to create the new measure (I could not get the green label to populate, but the red did and that was fine the green items were just left blank which works too)however, you cannot add a measure in the advanced controls part of the map. (Measure is not selectable)

I tried creating a column with the data from the measure, using this:

Completed = if(Table[Conditional] = "Red",0,1)

Just to get 1's and 0's in the column but then I get this error:

Function 'PLACEHOLDER' is not allowed as part of calculated column DAX expressions on DirectQuery model

Any ideas?

[Anonymous]

Hi @derektd @deldersveld 

I am having a similar issue. I need to conditional format shapes of map, but i have 4 different options (1,2,3,4 corresponding to 4 different colors) instead of two.

Did you get to solve it? In that case, How did you manage?

Thanks in advanced!

[derektd · Accepted solution]

I was able to get the DBA to create view that included nulls for items that did not have a date in the selected range, then I was able add to the map and use one color for the Blanks and one color for the ones with a "1" This solved the conditional formatting of the bubbles by completion.