Date Table Relationship not functioning properly

Nickr1991 · ‎11-29-2017

Hello, I have an issue and I have already researched it here and none of the current solutions work.

Here's the issue. I have a dashboard that I am building and the Date table has relationships with 3 different tables.

The fields that are related all have the same Data Type. I can use the date table to filter with two of the tables, but on the third table, it does not work at all. No matter what Date I choose nothing gets returned.

Anyone have any ideas?

Thanks!

parry2k · ‎11-29-2017

can you confirm if relationship is active?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Nickr1991 · ‎11-29-2017

Here's the relationship

And yes, they are the same data Type and format. They are both type "Date", the format is "dddd, MMMM d, yyyy", and the relationship is active.

For the life of me I cannot understand why this isn't working.

Thanks for the help!

parry2k · ‎11-29-2017

Weird, i think it will good to know if you are using measure or there is any other relationship with this table which is not letting it filter.

Can you remove relationship with other table and just test with this one table and remove all other relationship etc. I'm sure you already done it but there is no other way to debug it since not sure what else is there.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Nickr1991 · ‎11-29-2017

So the only tables interacting in the visual are the Users Table and the Jobs Table. I am trying to filter based on the Created On field in the Jobs Table, which is where the relationship is. Date connected to Created On. I tried removing all the connections from the date table that could screw it up and it still didn't work. When I create a table visual and have it pull in the Job.Job, Date.Date, Job.Created On it shows values for Job and Created on, but Date is blank. I'm out of ideas on what could be wrong

parry2k · ‎11-29-2017

sorry @Nickr1991 I guess only way is to see your data and test at my end. If it possible share, mask sensitive and I can try.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Nickr1991 · ‎11-29-2017

I'm currently working with it in Power BI Desktop, and don't have it sharable. I also don't feel comfortable sharing out the data unfortunately. I appreciate the offer though. I'll keep working on it and when I figure out the problem I will update here.

Thanks!

parry2k · ‎11-29-2017

@Nickr1991 sounds good, although best is always to put data in excel in share (remove any sensitive data), anyhow, good luck, if need help, just reach out. cheers!

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.