Forum Discussion
Table relationship does not work
Hello,
I have established the relationship between this tables below. One slicer for Month and One slicer for Year, now I am having problem with the Year slicer as my charts does not respond when I choose on any year. I have no problem with my Month slicer as it works fine. I don't know if there's still a relationship I need to establish? All tables connected to Sort-Month tbl have the same relationship as Sort-Year (Many to One).
Thank you guys for your help.
Hey Anonymous ,
as i can see from the picture, almost every relationship of the year table is inactive (dotted lines), consider to make these relatioships active.
Regards,
Tom
3 Replies
Hey Anonymous ,
as i can see from the picture, almost every relationship of the year table is inactive (dotted lines), consider to make these relatioships active.
Regards,
Tom
It's so simple I am sorry I have to asked this one. Thank you TomMartens! It works now.
Sometimes it's simple, sometimes it's not. Sometimes we overlook dotted lines where there should be straight lines. No reason for being sorry.