Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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...
Need Help
  • v-joesh-msft's avatar
    v-joesh-msft
    6 years ago

    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.

     

     

v-joesh-msft's avatar
v-joesh-msft
Icon for Solution Sage rankSolution Sage
6 years ago

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

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.