Forum Discussion
np123
9 years agoAdvocate I
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...
bullius
9 years agoHelper V
Hi np123,
Try this...
The direction of your relationship between the Relative_Calendar table and the Dim_Dates table is the wrong way around.
Try deleting it, then dragging Date_id from the Relative_Calendar table to the Dim_Dates table.
You want the little black arrow on the joining line to point from the Relative_Calendar table to the Dim_Dates table.