Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Query in table relationship

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 ?

 

 

Need Help

3 Replies

  • Dhacd's avatar
    Dhacd
    Resolver III
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      hmmm. still not able to work 

      • Dhacd's avatar
        Dhacd
        Resolver III
        4 years ago

        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.