Forum Discussion

damit23183's avatar
damit23183
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago
Solved

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

  • 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's avatar
      damit23183
      Icon for Microsoft Employee rankMicrosoft Employee

      Thanks Amit. It perfectly Worked.