Forum Discussion
Count vs displaying value in graph
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:
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
11 Replies
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 !!!
LinkedInHi 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 !!!
LinkedInHi 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.
Thank you for the date equivalent recommendation.
