Quickinfo doesnt match the x-Axis

[SchmitKS]

Hey there, 

I am trying to visualize the amount of overdue and intime taskes im comparison with new tasks coming up each month. I set the due date to the end of each month. Having this in the chart diagram, it shows me the month before on the x-axis, as you can see in the picture below. Does somebody have an idea, whats going on there? 

Thank you for your help! 

Kim 

[v-kelly-msft]

Hi @SchmitKS ，

It's a normal case,as you see below:

As you see,the X-axis shows July 2020,but the Quickinfo shows June 30,it's not a problem,when you have 2 days which are closer,such as June 30 and July 1,the related values will show together above the same X-axis dimension.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[MFelix]

Hi @SchmitKS ,

Are you using a calendar table or a date column from your data table?

If you are using a date column from your dataset you will pickup the highest value on that month that is withing the selection you made because your dataset doesn't have those dates.

In the case of time values the best option is to create a calendar table with unique values for each date starting on 1 of january until 31 december (start and ending year is as you need) and that will give you the month end as you need.

[SchmitKS · Accepted solution]

Hey Miguel, 

thanks for your response! 

I used a calender table which was linked to the dates in my data table 😉 

I found out, that I had to change the type of my x-Axis to Category. 

Now it works 🙂 

Best regards, 

Kim