Why is graph summing all the values YTD?

[LFM]

I want to make a graph that shows Net P/L YTD. When Im trying to create a graph it seems to just sum all the values YTD for 2024. I want to see Net P/L each day over time.

[lukiz84 · Accepted solution]

then you have to add the correct field to the x-axis

[Anonymous · Accepted solution]

Hi @LFM ,

Thanks @lukiz84  for the quick reply. I have some additions to this:

(1) This is my test data. 

(2) When your x-axis places the date hierarchy, you need to drill down to a different level to present the data.

Please refer : Drill mode in the Power BI service - Power BI | Microsoft Learn

 

If you don't want to show different levels of data, you can change the x-axis to a date format.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[lukiz84 · Accepted solution]

then you have to add the correct field to the x-axis