Data visualisation issue

[JoWingsGSE]

Hi again,

I think I may have been spending too long staring at the same thing.  Per the attached, I have set the data to show October 2023, however the figure shown is YTD figures. Where have I gone wrong and why is it showing the total amount billed year to date instead of just the month of October?

Thank you in advance!

[JoWingsGSE]

Good morning!

Having had some time away, I have looked with fresh eyes and it was as simple as your first option.

Thank you 

[JoWingsGSE]

Thank you for taking the time to reply.

Nett Sale is just on the Y axis, I was adding and removing it when taking the screen shot. 

X = Date, Y = Nett Sale

The Collection & table is related to the Invoiced Jobs table correctly  with the same reference.

[Anonymous · Accepted solution]

I think there can only be a few possible explanations:

1. It actually shows you the correct sum and you confuse it with showing the sum of the year since the x-axis tells you so (you have to go down 1 step in the hierachy for the x-axis to show you the month as well)

2. Relation between the collection.. table & Invoiced_Jobs.. table is not proper

3. Not sure but if "Nett Sales" is actually some weird measure e.g. incl. ALL() function there might be your issue as well

[JoWingsGSE]

Thank you - I shall do some digging as a similar data set worked perfectly last week - I have working on this data set for hours today so might need a break and to come back to it with fresh eyes.  I will update once I have gone through your suggestions 🙂

[Anonymous]

Why is Nett Sale on the X-Axis as well?

And is the Collection &.. table properly related to the Invoiced_Jobs.. table?