Forum Discussion
Power BI- Risk Matrix- Scatter Chart- Count Display
Hope i get some help to resolve the issue I'm facing. Created a Risk Matrix Below is the screenshot Trying to create a scatter chart and show the count of coordinates that is showing in...
Anonymous lbendlin
Apologies! Been with clients. Okay, so you want to do the following:
- Do a measure Max Likelihood = MAX ( Table[Likelihood] )
- Do a measure Max Consequence = MAX ( Table[Consequence] )
- Do a Calculated Column = Table[Likelihood] * Table[Consequence]
- Add the Measures on the X and Y Axis
- Add the Calculated Column as the Details field.
Apologies for earlier as I wasn't making very much sense when I was referring to the MAX and Risk Ratings. Hopefully the above makes more sense.
Also, you can change the Details to whatever you want and that will change the Category Label 🙂
Hope this helps!
Theo
Anonymous did this resolve your issue? If so, please accept as solution.