fbcideas_migusr
2 years agoNew Member
Status:
Need Clarification
Wrong cross filtering behavior when using Field parameters (!)
Basic scenario (without Field parameters):
- two visuals on a page: matrix1 with Product Groups and below that Products on the rows, and matrix2 with Customers on the rows
- drill-down on a specific Product Group in matrix1
- Power BI cross-filtering automatically adds a filter on the same Product Group to matrix2 (this way the filter context and totals stay the same in the two matrices)
- drill-up in matrix1
- Power BI automatically removes the filter also from Matrix2 (keeping filter context and totals the same in the two matrices)
Same scenario with Field Parameters in matrix1:
- matrix1 again has Product Groups and Products on the rows, but this time as Field parameters selected through a slicer
- drill-down on a specific Product Group in matrix1
- Power BI cross-filtering automatically adds a filter on the same Product Group to matrix2
- then, another Field (e.g. Month) is selected for the rows of matrix1 (via the slicer with the Field parameter)
- Power BI automatically removes the Product Group filter which was a result of the earlier drill-down, and all Product Groups are in the filter context (this behavior can be justified I think)
- however, the Product Group filter is kept on matrix2 (and any other visuals on the page), and the matrices now have different filter contexts and different totals which is very confusing
- making matters worse, it is very difficult to get rid of those "hanging" filters! So far only "Reset to default" seems to clear them.
Can this be investigated and corrected? Field parameters are an absolutely great feature, but the above behavior creates a high risk of inconsistent figures and confused users!
2 Comments
- fbcideas_migusrNew MemberStatus added:New
- jeroenterheerdt
Microsoft Employee
Status changed:NewtoNeed ClarificationI beliee this is already fixed.
Recent ideas
Add standard ADBC search paths for ADBC drivers in Power BI
Considering the benefits of using ADBC drivers for data intensive operations, it would be nice to allow ADBC drivers to be used that are not necessarily packaged with Power BI installations. To mitig...hsadlier-pdx1 hour agoNew MemberNew4Views0likes0CommentsPower BI Subscriptions: Suppress OOO Replies and Improve Sender & Management Options
With the recent changes to Power BI subscription email delivery, Out of Office and other automatic replies can be returned to the individual subscription owner. For automated subscriptions sent to l...svcrowell2 hours agoNew MemberNew14Views2likes0CommentsAbility to change the hover text on the new List filter
It would nice to be able to change the hover / tooltip text on the new List filter (preview) visual. For example, currently if you have more items selected than can fit in the available space it say...EHA_SD7 hours agoAdvocate IVNew4Views0likes0CommentsDisplay the associated Power Automate flow in Power BI
When using a Power Automate visual in Power BI, it is not easy to identify which flow is currently associated with the button. Expected improvement: Display directly in the visual properties: Flo...Olivier-R357 hours agoNew MemberNew4Views0likes0CommentsAdd a built-in “Allow Direct Manager Access” option for RLS
Hello, Please consider adding a built-in RLS option in Power BI / Fabric to allow direct manager access based on the existing organizational hierarchy in Microsoft Entra ID / Azure AD. This is a ve...Haroldhngn7 hours agoAdvocate INew3Views0likes0Comments