Map visual bubble is a line instead of a bubble with negative percentage values

[Ardydardy]

I would like to see bubbles as below, but when I use a percentage value I get the results above???

Anybody know how I can achieve normal bubbles with percentage values?

[v-nuoc-msft · Accepted solution]

Hi @Ardydardy 

For your question, here is the method I provided:

Here's some dummy data

“Table”

Create a measure.

Percent % = 
var _abs = ABS(SELECTEDVALUE('Table'[Values]))
var _value = SELECTEDVALUE('Table'[Values])
var _total = 
    SUMX(
        ALL('Table'),
        _abs
    )
RETURN
DIVIDE(_value, _total)

Here is the result.

If you're still having problems, provide some dummy data. It is best presented in the form of a table.

Regards,

Nono Chen

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

[v-nuoc-msft · Accepted solution]

Hi @Ardydardy 

For your question, here is the method I provided:

Here's some dummy data

“Table”

Create a measure.

Percent % = 
var _abs = ABS(SELECTEDVALUE('Table'[Values]))
var _value = SELECTEDVALUE('Table'[Values])
var _total = 
    SUMX(
        ALL('Table'),
        _abs
    )
RETURN
DIVIDE(_value, _total)

Here is the result.

If you're still having problems, provide some dummy data. It is best presented in the form of a table.

Regards,

Nono Chen

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

[Ardydardy · Accepted solution]

Hi! Thank you so much for your help. I really appreciate it 😍. I am only using measures compared to last year measures and I worked out that the problem was mostly due to problems/multiple values in the data model.