Forum Discussion
How to stop a Text field from counting
You could try creating a Measure:
Pie Slice NoCount = FIRSTNONBLANK(#"TableName"[Pie Slice], TRUE())
and then use that measure in the scatter plot?
I use that trick for having text values display on tool tips.
Thank you! I'll give that a try. I've been able to create a measure, so I'm hopeful I'll be able to give it a good test.
I've added the new measure but when I add it to the Y Axis it's still showing values of 0 through 10 instead of the text values, so I'm thinking I still haven't gotten it quite right.
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.
