Scatter Chart

[WILLIH]

I'm using a priority column and risk column that I would like to put into a scatter chart. The values I'm using for these columns are High, Medium and Low. I added two additional columns to table A to give each value a score of High = 3, Medium = 2 and Low = 1. I did this for both priority and risk. I want to use the new columns in a scatter chart to see where each priority/risk pair falls.

When I add the two new columns to the scatter chart on the X and Y axis it gives me the 1st picture below. If I add a value to the Details field it complety breaks the chart as you can see in the 2nd picture below

Is there a better way of doing this? How do I get my values to scatter?

 

[v-lionel-msft]

Hi @WILLIH ,

First of all, the [Value] field is aggregated but the [priority column] field and [Risk column] field are not aggregated, so the above error appears.

If you want to resolve this error, you can perform this operation, but it does not make any sense.

You should probably add your fields this way, which will be more helpful for analysis.

Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@WILLIH I think I know what is going on, can you send sample pbix file without sensitive data and I can take a look. and get you the solution.

[WILLIH]

Hi parry2k

Thank you for your response. I got it working to which I have realize I don't think it will give me what I'm looking for. Because each line item will fall into 1 of 9 possible buckets (Risk high, low, medium) vs (Priority high, low, medium) the current will give me just 9 points which what it's showing.

Do you have any suggestion on how I could possibly show the number of line items that fall into each high, low and medium bucket?