Forum Discussion
How to create Custom Median line on Scatter Chart
Hi,
I am creating scatter chart based on some variance calcualation. Everything is good just need to draw custom line in that chart where I need some help.
For example I have this scatter chart:
As you can see all values are above 0.7 but median line is showing at 0.75.
I would like to create custom median line on 0.7 so i can show all above 0.7 as green dots and below 0.7 as red dots.
Everything is working except Custom MEdian line. Is there a way I can create Custom median line?
Thanks
damit23183 , Create a measure using median or medianX and use that in constant line
or maybe you need a measure like
medianX(Values(Table[Gender]) , [RR])
2 Replies
- amitchandak
Super User
damit23183 , Create a measure using median or medianX and use that in constant line
or maybe you need a measure like
medianX(Values(Table[Gender]) , [RR])
- damit23183
Microsoft Employee
Thanks Amit. It perfectly Worked.