Forum Discussion
Interactions
Hi BI Community! I have searched the forum but didn't get an answer for my issue. I am working on the report, it uses two datasets: 1. Microsoft Planner data exported to Excel, and from Exce...
Hello AgataJ ,
there should be a relationship built in the data model between these two tables.
I advise you to create dimension tables that are linked to both of your table so you could filter between them.
check this concept here https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡