Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi parry2k
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |