Forum Discussion

MapleCookie's avatar
MapleCookie
Icon for Helper II rankHelper II
1 month ago
Solved

Power BI PL 300 question - Edit interactions to Filter & Matrix

  Hello, I would love to confirm my answer to the following Power BI question.  Visual Type: Matrix Set: Edit Interactions to Filter   if disagree with the above answer, please tell me why.  Ad...
  • rohit1991's avatar
    1 month ago

    Hii MapleCookie 

     

    Your first choice, Matrix, is correct. However, select Apply drill down filters to Selected visual. This keeps drill-down changes within the matrix, while selecting a matrix cell can still filter the card and bar chart. Edit interactions to Filter controls normal visual selections, not drill-down behavior.

    The link below clearly explains this:

    https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop 

  • Prince0011's avatar
    1 month ago

    Hi User,

    For this question, the correct answer depends on what the requirement is asking, but if the goal is to control how one visual affects another visual on the report page, then Edit interactions → Filter is the correct option.

    When you select a visual and enable Edit interactions, Power BI provides options such as:

    • Filter → The selected visual filters the data shown in another visual.

    • Highlight → The selected visual highlights the related data but keeps the remaining data visible.

    • None → The selected visual does not affect the other visual.

    For a Matrix visual, choosing Filter means that when a user selects a value in the matrix, other visuals on the page will be filtered based on that selection.

    The option "Apply drill down filters to selected visual" is different. It is related to drill down behavior, not visual interactions.

    Drill down filters are applied when a user navigates through a hierarchy inside a visual, for example:

    • Year → Quarter → Month

    • Country → State → City

    When drill down is activated, Power BI changes the level displayed in that visual and applies the drill-down context. It does not control whether one visual filters another visual.

    So:

    Edit interactions → Filter = Controls cross-filtering between visuals.
    Apply drill down filters to selected visual = Controls filtering behavior while drilling down within a hierarchy.

    For PL-300 exam questions, remember:

    • "How do you make one visual affect another?" → Edit interactions

    • "How do you navigate from summary to detailed levels?" → Drill down

    For more information:

    Hope this clarifies the difference between these two features.

     

     

    💡 Helpful? Give a Kudos 👍 — keep the community growing.

    Solved your issue? Mark this as the Accepted Solution ✔️

    Best regards,
    Prince Singh | Data Science & Microsoft Fabric Enthusiast