- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Can't determine why some data is not being displayed
So I am trying to determine why I can see the total in one of my visuals when I sort by certain categories (in this case using the slider for "Preventative Maintenance"). Note that the total amount of house spent on this task is 40.15 hours, but it is only showing .20 hours and for one Work order. It does show the totals at the bottom but unclear why the full list that makes up the totals is not being displayed.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @ChrisAZ ,
The many-to-many relationship is created between the Labor and Parts tables through 'Work Order'. If you choose to use the Labor table's 'Vehicle', then the 'Worker Order' should also be Labor.
Best regards,
Mengmeng Li
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @ChrisAZ ,
It's hard to see the cause of the problem just from the screenshot, please provide a public link to the pbix file (doesn't include private data).
Best regards,
Mengmeng Li
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @ChrisAZ ,
It is always tough to diagnose soemthing from one screenshot. But, is there a filter on one of the visuals that is not on the other? In the "paid vs work hours" visual, what happens if you re sort that by the hours, does it show up? Or, do all the hours that are missing belong to the blank line - "Jordan"?
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
Private message me for consulting or training needs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Here is the link to the PBIX file
https://drive.google.com/file/d/19mpW2gCHJ01jhO0NuKS38d_5MdP7oIuZ/view?usp=drive_link
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @ChrisAZ ,
The many-to-many relationship is created between the Labor and Parts tables through 'Work Order'. If you choose to use the Labor table's 'Vehicle', then the 'Worker Order' should also be Labor.
Best regards,
Mengmeng Li
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank you! That works now!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello,
The blank line for "Jordan" is not really part of the issue, it just so happens that he is not one of the employees that did this task. I am just unclear on why I see the tools in the bottom right, but in the data above it is only showing one entry. What else might I include that could help diagnose the problem? I could include the entire PBIX.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-13-2024 01:40 PM | |||
06-25-2024 11:51 PM | |||
11-30-2023 12:30 PM | |||
04-19-2024 10:30 AM | |||
04-29-2024 05:23 AM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |