This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
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.
Solved! Go to Solution.
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
Sometimes it's simple, sometimes it's not. Sometimes we overlook dotted lines where there should be straight lines. No reason for being sorry.
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.
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 31 | |
| 22 | |
| 15 |
| User | Count |
|---|---|
| 74 | |
| 61 | |
| 31 | |
| 31 | |
| 23 |