Forum Discussion
Visual interactions not working
I am struggling with getting my visuals to interact correctly. The visuals are from the same table. The columns of interest in the table are Child ID, Event, and Event Status. Every ID number is a...
Hi Melodyv ,
According to your statement, I think your issue should be casued by your data model.
Firstly, please make sure whether [Gender] column and the [DECA Fail/Pass] columns are in the same table. I think they may not in the same table, and many to many relationship will cause this issue. You can try to add Dim table to create Star structure
For reference: Understand star schema and the importance for Power BI
Apply many-to-many relationships in Power BI Desktop
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.