Forum Discussion
Trouble with Line Chart
I am trying to produce a line chart but I'm having issues with it producing the correct information. Here is an example of my data:
When I try to set the line graph I am getting this as the results:
Here is what I have set in the fields:
As you can see, the total in the chart does not match the total on the graph. What am I missing?
I'm not sure what else to do.
Anonymous you are at the year level and it will sum all the records for that year, if you drill down to date level, you should see the sum of the date.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
4 Replies
Anonymous you are at the year level and it will sum all the records for that year, if you drill down to date level, you should see the sum of the date.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Anonymous regardless of the data, visualization depends on what you are trying to achieve, if you have a lot of unitcode, of course, it will look crowded as you put it on the legend. So it comes out what business goal you want to achieve thru data.