Forum Discussion
Trouble with Data Count
I have a large database with various financial metrics including stock price. I want to show the trend of the stock price over time, however the line chart is displaying the count of stock price and I cannot figure out how to change this. The table below gives a basic idea of what the data looks like. Any suggestions?
| Date | Company A |
| 09/24/2007 | 40.87 |
| 09/25/2007 | 40.13 |
| 09/26/2007 | 40.4 |
| 09/27/2007 | 40.75 |
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:
5 Replies
Out of my understanding, you need Company A values as a Line against the dates.
Just drop the Date column into axis field(remove date hierarchy and select Date) and Company A into values field.
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:
if the values are formatted as decimals not text, you should just be able to put date into axis and company into values.
