I have a filter called Country. It has two values (Canada, USA).
When dashboard opens and I click on this filter I see both values in white indicating that they both exist in the data. When I select Canada I get records. When I select USA I get nothing.
Might be your data model - USA & Canada could be in a field on one table and your visualisations on your sheet from another table, where linked records only exist for Canada?
That would seem reasonable. However, I only have a single Fact Table in my data model and it contains this field. I'm sure has something to do with my data model. I just can't figure it out.
