Relationships not working

[Juramirez]

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

[Anonymous]

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

[pxg08680]

@Juramirez

Because your join is resulting only Feb data.

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

[Juramirez · Accepted solution]

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

[Vvelarde]

@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