Forum Discussion
Show items with no data using bins not working
Hi all,
As you can see in the added photo, I'm trying to get my lower right table to show the data for all bins of the group column 'Woonoppervlakte (bins)' that I created. However, when I select the 'show items with no data' for this column in the visual, no changes occur and thus not all bins appear. The bins should start at 20 and go up to 200.
Information online regarding the subject does state specific situations in which the 'show items with no data' option does not work, however this does not seem to apply to this case.
https://www.enjoysharepoint.com/power-bi-show-items-with-no-data/
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data
Some more information that can be useful:
- The question only concerns the lower right table;
- The green filter applied to the visual ('Soort OG') filters based on one of two categories all rows in the data adhere to;
- The only other filters / slicers applied to the visual are those shown in the left of the dashboard;
- The other dashboard pages have no connection to this page or the other way around, thus these are irrelevant.
I find it difficult to share more information due to privacy issues. Therefore, I hope my question is not that difficult and it can be resolved using only the added photo. If more information is required, let me know. Thanks in advance!
First question I have is this
(i) Do you have Bin as lookup/dimension table, containing the full list of bins?
If you do not have the master list of bins data in a table, then you should create one and then create the relationship to the transaction table that you used in the visual.
(ii) If yes, are you using the column from this table to this visual?
if not, you have to use the bin table column/field.
"Show items no data" will show only if you have master list and then the measure is null/blank.
Second part
If above is not working and the fix is not the case for the issue, let us try as iterative approach
Identify / trouble shoot - visual level issue or page level issue i.e., due to other visual issue:
a) Make a copy of the file and create duplicate of the page
b) Remove all except the lower right table and see if that brings the items with no data.
c) If items with no data shows up then we can slowly add one after another visual to the page. We can identify the issue what is causing. Also pay attention to sync slicers.
d) If items with no data DOES NOT shows up then the issue has to do with the visual itself. Work on it to get the show items no data
Hope this helps!
3 Replies
sevenhillsSuper User
First question I have is this
(i) Do you have Bin as lookup/dimension table, containing the full list of bins?
If you do not have the master list of bins data in a table, then you should create one and then create the relationship to the transaction table that you used in the visual.
(ii) If yes, are you using the column from this table to this visual?
if not, you have to use the bin table column/field.
"Show items no data" will show only if you have master list and then the measure is null/blank.
Second part
If above is not working and the fix is not the case for the issue, let us try as iterative approach
Identify / trouble shoot - visual level issue or page level issue i.e., due to other visual issue:
a) Make a copy of the file and create duplicate of the page
b) Remove all except the lower right table and see if that brings the items with no data.
c) If items with no data shows up then we can slowly add one after another visual to the page. We can identify the issue what is causing. Also pay attention to sync slicers.
d) If items with no data DOES NOT shows up then the issue has to do with the visual itself. Work on it to get the show items no data
Hope this helps!
- sevenhills
Glad it helped and worked 🙂