Forum Discussion
Helper IIIAnother strange problem with a slicer
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:
- 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.
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.
7 Replies
- JarroVGIT
Resident Rockstar
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! 🙂
- 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 🙂
- JarroVGITYou 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.
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.
rbartlejrThanks 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.