Query in table relationship

[Anonymous]

Hello everyone, I have face one question. 

Below are the relationship between 'Calender" and 2 "Supplier Performance" Table. 

 I have created a chart below, based on the column below (X axis = [Date] column from 'Calendar', Y axis= a column from 'Supplier Performance',  Secondary Y-axis = a column from another 'Supplier Performance'

However, the weird part is. i dont have data from Jan to May in both Supplier Performance table, but it is still showing something there. may i know how can i solve this ?

[Dhacd]

Hi @Anonymous ,

Can you add the year column to the slicer and try to change the year the data is currently pointed to?
Currently, data is aggregated by months.

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

Thanks and Regards,
Atma.

[Anonymous]

hmmm. still not able to work 

[Dhacd]

Can you show me a sample data.
Or Check if the order for month and day is matching with the data set in power query.

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

Thanks and Regards,
Atma.