Forum Discussion
Solved
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 ...
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
