Forum Discussion
Visual is not showing all data
I am new to Power Bi so maybe this is a simple fix. I have created a visual that is intended to show the count of users by region. However, after a certain number of regions the list just stops. I have checked my data to ensure there ARE rows that contain the missing regions. I have tried swapping in other fields instead of region and they do not cut off in this way. I did not add any filters or slicers to the visual. Any ideas about what could be causing this? Thank you!
tralliott At the beginning of your table there is an empty cell (with no region name) that counts around 697 users.
Please check if that empty cell is counting the users that are missing in the region names.
Please check how is your semantic model built. I mean, check the values used to show the regions (are there any empty values?), check the values used as keys in the relationship (are there any values that are wrote in a different way between the two tables -try to figure out if you have some misspelling, or special characters, or capital letters , or any kind of symbols or space that breaks the relationship you are expecting-?)
6 Replies
tralliott At the beginning of your table there is an empty cell (with no region name) that counts around 697 users.
Please check if that empty cell is counting the users that are missing in the region names.
Please check how is your semantic model built. I mean, check the values used to show the regions (are there any empty values?), check the values used as keys in the relationship (are there any values that are wrote in a different way between the two tables -try to figure out if you have some misspelling, or special characters, or capital letters , or any kind of symbols or space that breaks the relationship you are expecting-?)
Pls check pcoley 's answer and also check if there are any other visuals on page that are filtering your table. Sometimes visuals get cross filtered.
In addition to what other users have mentioned, it’s worth checking for hidden slicers—you may have created one that’s not visible in the report view because it’s hidden or overlapped by another visual. Another way to verify whether all data is present is to switch to the Data/Table view, then copy and paste the data into Excel to confirm that the numbers are actually correct.
Check: the table is sorted by region_name and stops at "California" alphabetically, so anything after C is below the visible area. Scroll down inside the visual. If it truly stops, the column has blanks breaking the sort. Filter out the blank region_name or sort by the count instead.
tralliott
Please try to verify the total count of user Emails.
I mean check whether your data contains total 6383 emails or more. if it's contains only 6383 then other regions are wrapped in the blank entry and that problem could be of the referential integrity issue. And if your data contain more email, then hover the table and try to identify how many filters applied on that table and by doing this you can identify the cause of the problem.
If you found this useful then accept it as solution.It ended up being an issue with my semantic model. I deleted and re-created my dimension tables and it worked.
