Another strange problem with a slicer

[rbartlejr]

I have a problem with a slicer. I changed the key fields within my tables and it now shows a (Blank) as one of the slicer choices. Prior to changing the key (WO_Task_Asset field), which was just adding another field to the key, it worked fine. Editing the table and looking at the field there are no nulls. I have some screenshots:

[JarroVGIT · Accepted solution]

You have a relationship to the other tables right? 1 to many? So if there is a related column value that is not in this table with unique department values, then a blank is included in your slicer.

[Anonymous · Accepted solution]

Hi @rbartlejr ,

Assume you have table 1 with id 1 to 4 and table 2 with id 1 to 5 and there are relationship between table 1 and 2, if you are using id from table 1 as slicer, there's going to be a situation like this. Blank() means other ids in Table 2 instead of Table 1.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rbartlejr]

Thanks @Anonymous I understand. It just seems odd to me that it was working fine in the last iteration of the report. I'll go through the tables in Access and see where the problem lies.

[JarroVGIT]

Can you try to hide items with no data like this:

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[rbartlejr]

@JarroVGIT 

Show items with blanks is not checked. I checked it and still no change. And that field is in only one table, there isn't a division in any of the other tables.

[JarroVGIT · Accepted solution]

You have a relationship to the other tables right? 1 to many? So if there is a related column value that is not in this table with unique department values, then a blank is included in your slicer.

[rbartlejr]

@JarroVGIT 

It's odd because I have another report with the exact same tables with the exact same layout (1 to many and same fields in each of the three tables) that doesn't have this problem. I'm recreating a previous report that was based on Access tables and is using the same layout pulling from Oracle. I'll keep checking it to see if there are any other fields that might affect it. Thanks.

[JarroVGIT]

The blanks are probably coming from the related tables where there are values that do not correspond to any of the 4 options you have in your slicer. If there is another department in the other tables, that would be linked to a 'blank' Department in the slicer 🙂