Forum Discussion
Conditional Formatting in Maps
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.
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.
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?
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.
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!