Count vs displaying value in graph

[Celeana]

I am trying to generate a line graph but instead of getting an actual value, I get the count value.  How do I fix the issue? THANK you!

 This is my data:

This is the graph I am getting

This iare my columns:

More info:

[danextian]

Hi @Celeana 

You've added an implicit measure but you didnt tell what category this measure  needs to be broken down into. Your X-axis is empty.

Note: Your Month column is a text string and will be sorted alphabetically, April being the in the first order. Use a date equivalent of that column.

[Celeana]

Thank you for the date equivalent recommendation.

[ryan_mayu]

@Celeana 

what's the expected output?

[Celeana]

I am getting this:

[Celeana]

The expected outcome is the following: 

[ryan_mayu]

I didn't see company data in the screenshot of your data. Is this data in the same table or other table?

[Anand24]

Hi @Celeana,
If you are creating a line graph and taking month column (Text datatype) in Y-Axis or Secondary Y-Axis, Power BI is correctly showing the count.

Y-Axis of line chart should be a numeric field and hence you should take a numeric column in it. If you take any text column, Power BI will auto-convert it to count since you can't ideally visualize a text value on lines because it won't give you a data point for the graph to render.

For example, If you want to analyze month-wise total used or total remaining, your Y-Axis would be total used or total remaining column while you X-Axis would be Month.

Here's another example:

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Anand24 · Accepted solution]

Hi @Celeana,
If you are creating a line graph and taking month column (Text datatype) in Y-Axis or Secondary Y-Axis, Power BI is correctly showing the count.

Y-Axis of line chart should be a numeric field and hence you should take a numeric column in it. If you take any text column, Power BI will auto-convert it to count since you can't ideally visualize a text value on lines because it won't give you a data point for the graph to render.

For example, If you want to analyze month-wise total used or total remaining, your Y-Axis would be total used or total remaining column while you X-Axis would be Month.

Here's another example:

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Celeana]

[Celeana]

I changed Total used from text to whole number and it fixed the issue

[Celeana]