Forum Discussion

jakeryan56's avatar
jakeryan56
Advocate II
7 years ago

Help with formula for scatter chart

Hi team!

So I have created this visual using the scatter chart visual. Both axes are based off a score between 0 and 100.

I have created green, white and red zones to indicate different levels of performance.

 

How would I extract the performance level (green, white, red) through DAX formulas? I need this so I can create other calculations based on this but I have tried using If(and( functions and then got really lost because of the complexity of working in an extra dimension.

 

Any ideas?

Need Help

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    jakeryan56 ,

     

    Your requirement is not so clear. Could you share more details about the "performance level" you mentioned? If possible, please share some dummy data and show the expected result.

     

    Regards,

    Jimmy Tao