Forum Discussion
Trouble with Line Chart
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 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.⚡
That did help. Thank you.
But now the visualization does not look that great, especially when I add more UnitCodes.
Would you have any suggestions on how to clean it up?
I have created some slicers but it all looks terrible with anything else selected.
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.
HI Anonymous,
Maybe you can try to add a calculated column to group your 'unitcode' values as a subcategory, then you can use this subcategory on your chart legend fields to reduce the complexity of graph.
Regards,Xiaoxin Sheng