Forum Discussion
Slicer Issue
Hi there My transaction table has Rate, Product and District. Product names and district names are in the different master tables. When I filter for a product, the district filter shows blank. ...
Hi sturlaws
"What happens if you look at all products, but filter for a certain district?", this scenario works well
Also, I can filter the district and select products.
Regards
Jayanthan
Ok. The empty filter for district, does it happen for "every" product?
yes, it happens for every product
Not obvious whats going wrong, and difficult to troubleshoot without knowing the data. Here are some strategies:
-Verify that the tables are connected by the appropriate fields
-Inspect the fields connecting the tables, and look for values that occur in the connecting field of the fact table, but not in the connecting field of the dimension