Chart uses wrong date

[data_jo]

Hello Power BI-Community,

We are dealing with the following issue concerning our Recruiting Report:
In the underlying table, one row contains one application. There are separate columns for each of the various milestones in the process, i.e.:

• "Date when interview 1st stage scheduled", "Date when interview 2nd stage scheduled", "Date when further interview scheduled"
• "Date when interview 1st stage took place", "Date when interview 2nd stage took place", "Date when further interview took place"

  The report contains two charts: Number of interviews scheduled per month & Number of interviews took place per month. The issue is that interviews in 2nd stage or further are displayed in the month in which the interview 1st stage was scheduled/took place instead of being displayed in the month that they actually werde scheduled/took place

  Can anyone help with an explanation or a solution for our issue?

  Thank you in advance.

[data_jo]

Hi @v-jialongy-msft ,

the following links lead to the data samples. Currently the x-asis is only using data of the 1st interview scheduled/took place, but we actually need it to also show the correct numbers of 2nd and further interviews scheduled/took place.

We would be very happy if anyone could help.
Thanks in advance.

.pbix (download needed): https://drive.google.com/file/d/1mlrreOEV7hC9MwiOAWmsqoGznXv7eCui/view?usp=sharing

.xlsx: https://docs.google.com/spreadsheets/d/10RvfOHj12YqtwGo6A-bbjh_bnHtjbWbu/edit?usp=sharing&ouid=10043... 

[v-jialongy-msft]

Hi @data_jo 

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

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