Forum Discussion

Juramirez's avatar
Juramirez
Icon for Resolver I rankResolver I
8 years ago
Solved

Relationships not working

Hi all!

 

I have two tables, one with information about workers and the other with info about bills. I need that when I select a date from slicer (Wich have dates from Bills Table) the barchart gets update but it doesn't. I must have the date from Bills Table on slicer. How can i do this? I attach a PBIX file with example of my problem (I want the bar chart next to the slicer as the one below it.)


Regards

 

Need Help
Tutorial Requests
  • Juramirez's avatar
    Juramirez
    8 years ago

    I just solved it!

     

    I've had to create a new table that only has the Dates that are in my original Database, then I relate these new Date Field  to the others Date Fields in my existing tables and it works! Just have to remember that in the new table, it must be a unique date field for each one that exists in the original tables that are in the data base.


    Regards

4 Replies

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Juramirez

     

    You have only February result because: 

     

    The Only UniqueIdentifier that match with UserID (Workers Table) are 4,9 and 13.

     

     

    Regards

     

    Victor

    Lima - Peru

     

     

  • pxg08680's avatar
    pxg08680
    Icon for Resolver III rankResolver III
    8 years ago

    Juramirez

    Because your join is resulting only Feb data.

     

    You need to look through your data and make a join again.

    • Juramirez's avatar
      Juramirez
      Icon for Resolver I rankResolver I
      8 years ago

      I just solved it!

       

      I've had to create a new table that only has the Dates that are in my original Database, then I relate these new Date Field  to the others Date Fields in my existing tables and it works! Just have to remember that in the new table, it must be a unique date field for each one that exists in the original tables that are in the data base.


      Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I have two tables with Column name "Reference number" . i am traying to create a relationship but it’s not working

    any idea why

    Data Type is "Text" for both