Why is my line graph showing in a straight line

[Anonymous]

Hello,

So i am supposed to create a a graph but when i insert the value to the y axis, it shows it as "count" which led to it being a constant line graph. Is there any way i can fix this?

Here is an example of how my graph currently looks like and what i input for my data set.
If anyone knows, please help.
Thank you !

[Anonymous]

Hi, @Anonymous 

Thanks a lot for @Idrissshatila  and @RossEdwards answer, as @RossEdwards said, if your field is a text field then it shows Count, you can try to convert it to Whole Number, etc (if you can), if it didn't solve the problem, you can provide more detailed information, share pbix files without sensitive data, etc.

Text:

Whole Number:

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Idrissshatila]

Hello @Anonymous ,

it depends of how your data is structured, it may be because there's no relationship between the data table and the table that having the value field.

[RossEdwards · Accepted solution]

The field "Total wp qu...", do you only have 1 record per month per year?  By doing a count you are getting a count of how many records exist in your data?

Looking at your screenshot, it would seem that your field "Total wp qu" is a text field?  Being a text field, there are no math operations.  You would need to transform your field to be some type of number if you are looking to do something like get a sum total.

[Anonymous]

Hello!
Thank you everyone for the help but in the end what i went to do was go into excel, insert a table, selected the range and tick the first column as headers which allowed me to get the values in power bi.