Visualization interacting with data model

[millerz1]

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 between the two tables (date table I created based off a Power BI article) doesn't appear to be working as I would expect.  When a select a specific team in the bottom splicer, there is no change to the graph.

Any help would be greatly appreciated!  

Link to files 

[V-pazhen-msft]

@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.

[millerz1]

@V-pazhen-msft  @amitchandak Thanks!  That resolved the "Created Defects" working with the visuals.  However, I am still getting circular dependencies on the "Closed Defects" and "Assigned Defects".

After some digging around, does this have to do with having multiple "Calculate" columns in the same table?

Any help is greatly appreciated.

[amitchandak]

@millerz1 , Refer this blog on a similar topic can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

or

Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to...

[millerz1]

Thank you, I am getting closer.  Now I am not quite sure what I am doing wrong with the relationships.  I am getting circular dependecy errors.  Per the article, I tried swapping around the formula's and dropping the "userelationship" when activating/deactivating the relationships.  Updated the attached PBIX.  Any help would be greatly appreciated.