Forum Discussion
Trouble with Data Count
Change it to "Sum" or "Average" or any of the other aggregate measures; since you only have one value per date, "Sum" will work just fine.
In your case, "Average" might be the most prudent measure that you'd use in other visualizations, so I'd recommend you change the default aggregation. Select your Stock Price column and you'll find the option in the Modeling tab at the top. See screenshot:
I have this problem when PowerBI see's my numeric values at Text or another format. Make sure the column is formatted as Decimal Number or another numeric like value. FOrrest
I appreciate the response, however I am still having trouble. I have formatted the stock price column as fixed decimal (see picture below). When I add the stock pric to the line chart, it immediatley changes to 'count of stock price'. What do you think the issue is? Could it simply be due to the large data set?
Change it to "Sum" or "Average" or any of the other aggregate measures; since you only have one value per date, "Sum" will work just fine.
In your case, "Average" might be the most prudent measure that you'd use in other visualizations, so I'd recommend you change the default aggregation. Select your Stock Price column and you'll find the option in the Modeling tab at the top. See screenshot:
