Forum Discussion
Visualization interacting with data model
Hello, I am trying to create a chart where I can interact with it by selecting the relevant team to see the number of open, closed, and assigned defects by date. However, the relationship betwee...
millerz1
Based on the provided pbix, there is no relationship created between the dates table and Hypercare table, so you cannot use the GBS team to filer the line value [assigned defects]. Just add a relationship using Created On column should work. And you should change the the filter direction to both since you want to use the GBS team in the Hypercare table to filter the other 2 table columns.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.