Forum Discussion
Vijay08V
Helper III
2 years agoScatter Plot - Overlapping of data labels
Hello, I am trying to add a scatter plot chart to my report based on the calculated DAX measure. I am trying to make it look like a 3x3 qudrant to show different items that fall into each quadran...
- 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.
Vijay08V
Helper III
2 years agoHello Anonymous . Thanks ! it worked.