Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Candy_L
Frequent Visitor

Filter not working on one chart

Hello All,

Newbie here. My filter is not working for the chart on the right.

 

The values for the first chart come from the Plans table.

Actual = SUMX(Plans,Plans[ActualHrs])

 

The values for that chart come from the TM Daily table.  

Reporting % = AVERAGEX('TM Daily','TM Daily'[ReportingPct])

 

Thank you much! 

 

0Report.png

 

0Relationships.PNG

1 ACCEPTED SOLUTION

I got it to work, but I'll take a look at that article. I added a relationship between the Team table and TM Daily and that worked. I would think it unnecessary because Team is in the Team Member table which contains the hierarchy for my charts.

0Relationships2.PNG

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Candy_L , as per the model it should filter. check if the interaction is enabled

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

I got it to work, but I'll take a look at that article. I added a relationship between the Team table and TM Daily and that worked. I would think it unnecessary because Team is in the Team Member table which contains the hierarchy for my charts.

0Relationships2.PNG

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.