Forum Discussion
Filters have no effect on data
I've got a database that holds data modeled in the style of a star schema. I'm reporting on this data in power bi desktop, and I have a fact table a date dimension and a table for "relative dates...
I had the same issue while using filters from dimension table to act on fact table,
to resolve the issue: Make sure that all your dimension tables are connected to the fact table using the same preliminary key. Ie. All dimension files connect through the same unique identifier in the fact table.