Forum Discussion
Filter two visuals from two tables with one date filter
Hello bralenj ,
then I would suggest to work your model as a star schema.
check the concept of star schema data modeling
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
Super UserHello bralenj ,
the thing with the relation between calendar table and the misc table isn't active is that the combined view is filtering the combined misc and the combined view is being filtered by calendar table.
if you don't need the relation between the combined view and rhe combined misc table you could remove it and then you could make the relationship between the calendar table and the combined misc table active and it will work.
My challenge with this is I also want the relationship between the coaches. If I remove that relationship in favor of the date one, then I would need two filters for coach, one from each table. So it would create the same issue, just for a different field.
- Idrissshatila
Hello bralenj ,
then I would suggest to work your model as a star schema.
check the concept of star schema data modeling
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
star schema did the trick. thank you