Forum Discussion
Value missing from Slicer
Data value missing in Slicer.
Below "Type" "Category" "Detail" pulled from same table "Master Category", except "Date" was pulled from Calendar table
When i select like below, Value "C" and "F" and "G" had gone missing from Slicer "Detail", you can see from the table on the left, those 3 values exist. Any1 know why?
The relationship is as below, 3 tables were connected to a "Master Category" table which those slicers pulled from. And all the dates from those 3 tables were connected to the "Calendar date"
Try setting the relationship between Mater Category and Data -AD from bidirectional to single.
3 Replies
Try setting the relationship between Mater Category and Data -AD from bidirectional to single.
ImkeFoh yes, it works, why this one is "both" rest all "single", wired. thanks!!
