Forum Discussion
Show items with no data using bins not working
- 4 years ago
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!
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!
- Anonymous4 years agoNot applicable
Hi Sevenhills,
After some tinkering I found out that it was your first question / remark that did it. I needed a master list. Thanks for the extensive answer, it allowed me to work through the different possibilities!