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...
Looking at your pictures more closely, I may have got that wrong.
You might just want to filter by values in the Dim_Dates table.
Basically, you want the relationship direction to point from the table with your filter values to the table you want affected by the filter.
Let me know how you get on!
Ah, it sounds like it's a problem with the way I have modeled the data, as the relative dates table can contain the same date twice (for example, once for "this week" once for "this month" etc.)
