Forum Discussion
Scatter Plot - Overlapping of data labels
- Anonymous2 years ago
Hi Vijay08V ,
I made some changes on your code, we tried to use a tighter jitter control and then removed the MOD function, which allows each value to be randomly distributed and non-repeating.Actual Points (with Random number added) = VAR BaseValue = MAX( [Actual Points]) VAR Minvalue = SWITCH( TRUE(), BaseValue < 1, 0, BaseValue < 2, 1, BaseValue < 3, 2, 0 ) VAR MaxValue = SWITCH( TRUE(), BaseValue < 1, 1, BaseValue < 2, 2, BaseValue < 3, 3, 3 ) VAR Jitter = RANDBETWEEN(1, 10) / 100 VAR AdjustedValue = BaseValue + Jitter RETURN MIN(MAX(AdjustedValue, Minvalue), MaxValue)But this time, the random value of 0 will only be changed from 0 to 0.1, not from 0 to 1.
We can try to specify each value and then do a random number assignment.
Actual Points (with Random number added) = VAR BaseValue = MAX('Table'[Actual Points]) VAR Minvalue = SWITCH(TRUE(), BaseValue <1,0, BaseValue <2 ,1, BaseValue <3,2,0) VAR MaxValue = SWITCH(TRUE(), BaseValue<1,1, BaseValue < 2, 2, BaseValue < 3, 3,3) VAR Jitter = SWITCH( TRUE(), BaseValue = 0, RANDBETWEEN(1, 100) / 100, BaseValue < 1, RANDBETWEEN(-10, 10) / 100, BaseValue < 2, RANDBETWEEN(1, 10) / 100, BaseValue < 3, RANDBETWEEN(5, 15) / 100 ) VAR AdjustedValue = BaseValue + Jitter RETURN MIN(MAX(AdjustedValue, Minvalue), MaxValue)If you have any other questions, you can check out the PBIX file I've shared, I hope it helps you with your question!
Hope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Vijay08V ,
I made some changes on your code, we tried to use a tighter jitter control and then removed the MOD function, which allows each value to be randomly distributed and non-repeating.
Actual Points (with Random number added) =
VAR BaseValue = MAX( [Actual Points])
VAR Minvalue =
SWITCH(
TRUE(),
BaseValue < 1, 0,
BaseValue < 2, 1,
BaseValue < 3, 2,
0
)
VAR MaxValue =
SWITCH(
TRUE(),
BaseValue < 1, 1,
BaseValue < 2, 2,
BaseValue < 3, 3,
3
)
VAR Jitter = RANDBETWEEN(1, 10) / 100
VAR AdjustedValue = BaseValue + Jitter
RETURN
MIN(MAX(AdjustedValue, Minvalue), MaxValue)
But this time, the random value of 0 will only be changed from 0 to 0.1, not from 0 to 1.
We can try to specify each value and then do a random number assignment.
Actual Points (with Random number added) = VAR BaseValue = MAX('Table'[Actual Points])
VAR Minvalue = SWITCH(TRUE(),
BaseValue <1,0,
BaseValue <2 ,1,
BaseValue <3,2,0)
VAR MaxValue =
SWITCH(TRUE(), BaseValue<1,1,
BaseValue < 2, 2,
BaseValue < 3, 3,3)
VAR Jitter =
SWITCH(
TRUE(),
BaseValue = 0, RANDBETWEEN(1, 100) / 100,
BaseValue < 1, RANDBETWEEN(-10, 10) / 100,
BaseValue < 2, RANDBETWEEN(1, 10) / 100,
BaseValue < 3, RANDBETWEEN(5, 15) / 100
)
VAR AdjustedValue = BaseValue + Jitter
RETURN
MIN(MAX(AdjustedValue, Minvalue), MaxValue)
If you have any other questions, you can check out the PBIX file I've shared, I hope it helps you with your question!
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.