Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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?
Solved! Go to Solution.
Hi @Anonymous
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.
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.
Hi @Anonymous
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.
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.