Forum Discussion
michaeljc70
Advocate II
Advocate IIMake a column not sum/count
I've used Power BI quite a bit lately with a SSAS cube and some Sql Server queries and created many visualiations. I am still fairly new to this though and cannot figure this out. I imported a ...
I have this issue too. I tried all the suggestions but still get this count. Here you can see that it is labled as do not summarize and as text. This Location field is city, state combo. As you can see it is doing this for both the location field and the in/out texas field.
leonardmurphy
Skilled Sharer
Skilled Sharernzipp It'd be better to start a new thread than continue on the end of an old one but...
A scatter chart requires each axis to be numeric. You can't put text fields on the axis (unless you want to count them, which is what it's doing). You might want to look at a different type of visual, such as a matrix, depending on what your end-goal is.