cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Tables with Relationships Don't Filter as Expected

I'm testing out the relationship between two sheets, using a small sample size and dummy data, and I'm coming across some inconsistent behaviour that I'd like to fix.

 

One sheet, TITLES, contains the information for books (subject, publisher, etc.) and the second sheet, USAGE, contains a count of how many students have read the book each month. Both sheets are linked, in the Relationship Editor, by the books' ISBN.

I have a line graph, created using the USAGE table, showing the number of students that have read the book, and using the book's name as the legend. I've then created a slicer using the SUBJECT field from the TITLE table:

 

example1.png

 

Now, if I select English on the slicer, the two English titles and their values remain on the line graph, as expected. But if I select any other Subject, nothing appears. The only way to see the other three books' information is to select (Blank) on the slicer, despite the fact that they are all drawing their Subject data from the same table:

 

example2.pngexample3.png

 

Any ideas as to why this is occurring?

1 ACCEPTED SOLUTION

In the process of grabbing some screenshots, I discovered the error.

 

Though the sheets recognised each other, one sheet's ISBN column was text, the other sheet's ISBN column was a general format, so the values were being truncated!

View solution in original post

2 REPLIES 2
Community Champion
Community Champion

Hard to tell without seeing a sample of the data.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




In the process of grabbing some screenshots, I discovered the error.

 

Though the sheets recognised each other, one sheet's ISBN column was text, the other sheet's ISBN column was a general format, so the values were being truncated!

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors