How to display tool tip value as 0, when I don't have a record for any state in shape/filled map?

[nagavineela]

I have a requirement where I need to display 0 on the tooltip, when there is no record for the selected state in my dataset.

As an example - In the below-attached map, I do not have any records for Alabama in my data file, How can I display 0 when I hover on state Alabama? (Currently, it is not colored as do not have a record for Alabama)

[v-xicai]

Hi  @nagavineela  ,

Do the suggestions from engineers make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[Greg_Deckler]

@nagavineela - So typically, this goes something like:

Measure =
  VAR __Calc = <some calc>
RETURN
  IF(ISBLANK(__Calc),0,__Calc)

[nagavineela]

@Greg_Deckler , I created a similar function but when I filtered the map, I am still seeing the same issue of - not highlighting the states with no value.

Function:

Count =

Var Count1 = calculate(count(Table1[Column1]),Table1[Column2] = "X")

return if(Isblank(Count1),0,Count1)

In the below image, I filtered the chart based on one of my filters.

[v-xicai]

Hi @nagavineela ,

You may set the Value of tooltips box as "Distinct (Count)" like below.

Also you may try to change the COUNT function to DISTINCTCOUNTNOBLANK in your formula.

Best Regards,

Amy 

Community Support Team _ Amy

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