Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Return (Blank) after replacing data table

Hello,

 

I replaced a Sales data table. After replacing (loading, transforming, cleaning, formatting etc.) the Sales table seemed to work as well as the old Sales table.

However when I managed the relationship between the calendar/date table and the new Sales table  all visuals return: (Blank).

 

I configured it the same as with the old table;

- same relationship

- same column structure and column format

 

Seems there is something wrong with the relationship but I can't figure out what it is.

with relationship returns blank

without relationship returns value

 

Some help is much appreciated. 

 

Regards,

Marcrelationshipwith relationshipwithout relationship

13 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Anonymous ,

     

    I see in your screenshot that you have applied a FILTER for 2020.

    Do you have data for 2020 in both if your tables?

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello Pragati,

       

      Thnx for your reply.

       

      In both tables/columns I do have 2020 dates. 

      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi Anonymous ,

         

        The relationship between 2 tables is single directional. From which table are you using your DATE filter?

         

        Thanks,

        Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Try creating a new Calendar Table i,e CalendarTable1.

     

    Create the relationship with CalendarTable1 and see if you are getting the results.

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous 

       

      Thnx for your input!

       

      I copied the calendar in Powerquery to calendar2. 

      It does return a value in the visuals now. I don't know what was wrong with the old calendar then.

       

      However it still isn't possible to filter properly. When I try to filter an month/week or  other, value returned remains sum/total  of selected columns.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

         

        can you share your .pbix file.

         

        Regards,
        Harsh Nathani
        Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)