'Count of' is automatically considered while dragging sales column to Y axis of Bar chart

[ramakrishnavvss]

When i drag a Sales column to Y axis of bar chart, it is automatically showing as 'Count of Sales'. I wanted to see only Sales.

In Data, i have set Summarization=Don't summarise for Sales column. But i still see this issue. Is there a place where i can set X, Y axis also to Don't summarize? or How can i overcome this?

[v-stephen-msft · Accepted solution]

Hi @ramakrishnavvss ,

Agree with @indkitty . Because the sales field is in text type, and your visual is a bar chart, you can not display a value like "$ 1159200" with the text type. You have to insert the number type field to the x-axis to display.

Please go to the Power Query Editor, select the column and then click the 'Detect Data Type'. 

Click 'Close&Apply', now the sales field is what you want.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[indkitty]

Hi ramakrishnavvss,

Noticed your sales column is text format, could you change the format to currency format?

Let me know how it goes.

[PaulDBrown]

Create a measure  for sales using:

Sum Sales = SUM(Table[Sales])

and drag the measure into the Y-Axis