How do I get zero values to appear on a map as a bubble?

[Anonymous]

I created a map where I want to show the turnover % by state. The bubble size should reflect the %. However, in instances where the turnover amount is 0%, there's not bubble or data point.

I want there to be a bubble for 0% so users know that there are employees in that state and so they can hover over the bubble to get the tool tips. For example, see South Dakota which has 0% turnover.

Here's how I calculated Avg Vol TO

Avg Vol TO = (((sum('HR Turnover Master'[CNT - Vol Terms])/[Avg Count])/[Months Count])*12)

Avg Count = Average number of employees for the period
Months Count = Number of months user selected from the filters (so I can annualize the turnover %)

[Anonymous]

Hi @Anonymous ,

Have you tried to select 'show items with no data' from State? That should do the trick.

[Anonymous]

@Anonymous  I just tried that option on State but there is still no bubble on the states with 0%. That option didn't seem to  change anything on the map.

[v-joesh-msft · Accepted solution]

Hi  @Anonymous ,

Hi, please try with this Dax Formula in the measure:

Avg Vol TO = (((sum('HR Turnover Master'[CNT - Vol Terms])/[Avg Count])/[Months Count])*12)+0

or

Avg Vol TO =
IF (
    (
        (
            ( SUM ( 'HR Turnover Master'[CNT - Vol Terms] ) / [Avg Count] ) / [Months Count]
        ) * 12
    )
        = BLANK (),
    0,
    (
        (
            ( SUM ( 'HR Turnover Master'[CNT - Vol Terms] ) / [Avg Count] ) / [Months Count]
        ) * 12
    )
)

If it doesn't meet your requirement, kindly share your sample data if you don't have any Confidential Information.

Best Regards,

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

[Anonymous]

@v-joesh-msftThanks for the ideas. I tried both options and neither of them work. It appears that the tool is configured to not show 0 values, even if you have checked the option on the state to "Show items with no data".

However, you gave me an idea to try this option:

Avg Vol TO = (((sum('HR Turnover Master'[CNT - Vol Terms])/[Avg Count])/[Months Count])*12)+ 0.000000000001

The above formula worked because the value is no longer a zero and the bubble now appears. So, I will accept that as a workaround solution.