Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
  • sevenhills's avatar
    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!