Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have two tables which have a many (table 2) to one (table 1) relationship. I have a slicer applied to the second table. When the number of rows in table 2 related to a row in table 1 drops to 0 (due to the slicer), the row in table 1 will now no longer show up in any visualisation in that page.
How can I show a list of values in table 1 that have been filtered out due to the filter applied on table 2? My example here is to show a list of sites (table 1) for which there have been no inspections (table 2) in a particular time period (slicer).
Cheers
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
108 | |
90 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |