Forum Discussion
How to stop a Text field from counting
The scatter chart is to display points at the intersection of an x and y numerical value, combining these values into single data points. Both X and Y axis should be numeric field (like measures). If you put a category field, it will aggregate values with count function. This is the expected behavior of scatter chart. Generally, we should put the category field into Legend in scatter chart. For more details, please see: Tutorial: scatter charts and bubble charts in Power BI
In your scenario, I suggest you try other visual like "Line + Column" chart which can have timeline on X-axis and slice on Lengend.
Regards,
Thank you for the information! That makes sense. I'll give your other suggestion a try - I didn't know I could have a timeline in the Line + Column chart.