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 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 %)

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.

     

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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'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.