Slicer Issue

[jayanthan]

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. However, the table shows filtered data with districts. Please advise

*Note - Relationships are created between master and transactions using product id and district id

* I cannot recreate the issues in the sample data

Regards

Jayanthan

[sturlaws]

Hi @jayanthan, could you provide a screenshot of the model view of your model?

[jayanthan]

Hi @sturlaws 

Thank you for the prompt reply. As requested,  please find attached Screenshot of the model

Order fil is  transaction table, others are master tables

Regards

Jayanthan

[sturlaws]

The relationships of your model looks ok. What happens if you look at all products, but filter for a certain district?

[jayanthan]

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

[sturlaws]

Ok. The empty filter for district, does it happen for "every" product?

[jayanthan]

yes, it happens for every product

[sturlaws]

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