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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Aleiadeh
Frequent Visitor

Filter Visual not working with measure

Greetings,

 

I have an issue with my Bid Status Report on Power BI. Everythins seems ok and working fine, but I needed to make a measure in order to calculate some outputs from the row data (such as no. of contracts delayed from planned date). However, I add a new measures to clustered column chart ( the measure equation as per the below photo) then when I press to any result cloumn, the filter is not applied to the other visuals in the report.

 

I am relatively new to Power BI, so if anyone could explain to me why this is happening and how to go about fixing it, it would be much appreciated.

 

Untitled11.jpg

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

2 possible answers:

1- "Edit Interactions" - the other visuals don't react to changes from this visual. 

2- The other visuals are not at the same aggregation or context as the original visual (This is more likely).  You might expect the other visuals to do some complicated calculation taking into account the measure filter from the first visual but it doesn't work like that .  You can investigate by (click on part of the first visual) then  hovering over the funnel icon on the other visuals to see what 'filters affect this visual' - it might not  be what you think.

View solution in original post

1 REPLY 1
HotChilli
Super User
Super User

2 possible answers:

1- "Edit Interactions" - the other visuals don't react to changes from this visual. 

2- The other visuals are not at the same aggregation or context as the original visual (This is more likely).  You might expect the other visuals to do some complicated calculation taking into account the measure filter from the first visual but it doesn't work like that .  You can investigate by (click on part of the first visual) then  hovering over the funnel icon on the other visuals to see what 'filters affect this visual' - it might not  be what you think.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors