cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

1 to * Relationship yields blank results

Hi,

 

I did a simple 1 to * relationship between a DateTable and Customer table.

I inserted a table visual and no value is showing:relationship.pngrelationship2.png

 

How is that happening? 

Note i have no page, report filter besides the slicers in the screenshot...

1 ACCEPTED SOLUTION

Accepted Solutions

Re: 1 to * Relationship yields blank results

I found the solution by casting the column to date from the sql server query and it worked.

View solution in original post

5 REPLIES 5
Super User
Super User

Re: 1 to * Relationship yields blank results

is the [TransactionDate] in your Query1 set to date data type?

Super User
Super User

Re: 1 to * Relationship yields blank results

It might be a dumb question, but do you have any data from March 2019?  This would happen if there were no results.

Re: 1 to * Relationship yields blank results

yes

Re: 1 to * Relationship yields blank results

Yes

Re: 1 to * Relationship yields blank results

I found the solution by casting the column to date from the sql server query and it worked.

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)