The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to Solution.
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.
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.