Forum Discussion
Slicer showing partial data
Hi everyone,
I have a report with a Slicer(new) to ebanle manager to search an employee with its personal ID. The report is meant to track the training completed by team members. When I search for a person by the name, all information appears (training completion date, training title, training type) and then when I search by the ID, the tables that show different category of training don't show datas.
What am I missing? Can someone please help me?
Research with ID:
Research with name:
Thank you!
5 Replies
- SamWiseOwl
Super User
Hi Anonymous
Are the Name and SSIG in the same table?
If not I would check the relationship between the two tables.
The Dim table (1) can filter the Fact table (*) but not the other way around.
Also hover over your table visual and check the filter the slicer is applying.
Hi SamWiseOwl
The name and SGID are in the same table. The filters applied to the slicers are the same. I don't understand why it still doesn't work..?
- SamWiseOwl
Have you checked the Interaction settings between your objects.
Format -> Edit Interactions
It is very odd to be sure!
If you enter nothing into the SGID slicer is the table empty or full?
