Visual filter by Measure or maybe Conditional filter

Hi Mera9,
Thank you for reaching out to the Microsoft Fabric Community Forum. Thank you Cookistador, for your inputs on this thread.

Right now, the card and table are independent the table does not filter itself based on the "Yes"/"No" shown on the card.

• Visual-level filters in Power BI don't directly reference a value from another visual (card → table).
• Measures cannot directly control visual filtering unless specially designed.

They are missing a dynamic connection between the Card's logic and the Table filtering.

Create a New Measure to Filter the Table:

Show Row Based on Audit Card =

VAR HasOverdue =

    CALCULATE(

        COUNTROWS('AUDIT'),

        'AUDIT'[Audit] = "Overdue"

    )

RETURN

IF(

    HasOverdue > 0 && 'AUDIT'[Audit] = "Overdue",

    1,

    0

)

Now, go to the Table visual:

• Drag Show Row Based on Audit Card into the Filters pane of the Table.
• Set the filter to show only when Show Row Based on Audit Card = 1.

This way:

• If the card says Yes (overdue audits exist), the table only shows "Overdue" rows.
• If the card says No (no overdue audits), the table will show nothing.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.