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
Restore "no-reply" option for Power BI Subscriptions
Please add a setting in the Power BI Subscription pane to choose the sender identity. With the recent update the platform forces emails to route through the subscription owner's personal Exchange On...LenaFid19 minutes agoRegular VisitorNew234Views36likes10CommentsFabric Desktop: A Local Development Experience for Microsoft Fabric
One of the biggest challenges in Microsoft Fabric today is the one branch per workspace limitation, which makes it difficult to work on multiple feature branches simultaneously without creating separ...raym8540 minutes agoAdvocate INew1.4KViews15likes2CommentsAllow Power BI subscriptions to use a no-reply sender instead of the subscription owner's mailbox
Following the migration to the new email delivery platform, subscription emails now appear to come from the subscription owner. This generates large volumes of Out of Office replies, auto-replies, an...tm821 hour agoNew MemberNew45Views12likes2CommentsAllow Workspace Identities as an authentication method for Fabric SQL Databases
Currently the only method of authentication in Fabric pipeline connections to Fabric SQL databases is using OAUTH2, meaning that the credentials of a specific user need to be used (with all the atten...spencer_sa1 hour agoImpactful IndividualNew433Views12likes2Comments