Forum Discussion

derektd's avatar
derektd
Frequent Visitor
7 years ago
Solved

Conditional Formatting in Maps

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 wou...
Need Help
  • derektd's avatar
    derektd
    7 years ago

    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.

derektd's avatar
derektd
Frequent Visitor
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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!