Forum Discussion
X Y Scatter Plot chart
I want both my X and Y to be non summarised value. Consider my X axis is date and Y axis is my Expected IRR.
I have a few deals (samples) that's happening on the same day. I hope them to appear as seperated dots but now PowerBI is forcing me to summing them up. What should I do?
4 Replies
Anonymous
To create an X Y Scatter Plot chart in Power BI with non-summarized values, you can follow these steps:
- Drag and drop your “Date” column to the “X Axis” field well.
- Drag and drop your “Expected IRR” column to the “Y Axis” field well.
- In the Fields pane, under Values, click the dropdown arrow next to your Date field, Select "Don't summarize".
- Drag and drop a unique identifier column (such as a deal ID) to the “Details” field well.
- In the “Visualizations” pane, click on the “Format” button and select “Data colors”.
- Select the unique identifier column you added in step 5.
- In the “Data colors” section, select “By series”.
- Click on “OK” to close the formatting pane.
If you don't have a unique identifier for each deal, you might need to create one. This could be something like a Deal ID, a unique reference number, or any other field that uniquely identifies each deal.
If you find this insightful, please provide a Kudo and accept this as a solution.
Anonymous
Can you try to drag and drop deal ID to the “Legend” field.
If it works then mark it as a solution.
