Vizual Interactions

[ad23]

Hello All,

I am new to Power BI and trying to learn while creating dashboards. I am trying to create a dashboard on the SLAs and what I want is when I click on the fails in vizualization 1, I want to see only the records of the 'Fails' in Vizualization 2. But when I click on the 2 fails for SITE5 in viz 1, I get all 10 records of that site in Viz 2. I only want to see the records of the 2 fails. Could you please help. Much appreciated!

Viz 1:

Site	Pass	Fail	Total	SLA
SITE1	352	5	357	98.6%
SITE2	66	3	69	95.7%
SITE3	63	3	66	95.5%
SITE4	85		85	100.0%
SITE5	8	2	10	80.0%
SITE6	7	2	9	77.8%

Viz 2:

Ticket ID	Problem Name	Priority	Site	SLA	Create Date	Resolved Date
Ticket1	Carpentry	Routine	SITE5	Pass	5/8/2020 7:17	2/1/2021 7:52
Ticket2	Carpentry	Routine	SITE5	Pass	5/8/2020 8:34	2/11/2021 11:10
Ticket3	Painting	Routine	SITE5	Fail	2/2/2021 15:00	2/2/2021 15:15
Ticket4	Cleaning Requests	Urgent	SITE5	Pass	1/27/2021 11:26	2/2/2021 12:29
Ticket5	Electrical/Power	Routine	SITE5	Pass	12/30/2020 20:11	2/1/2021 11:12
Ticket6	HVAC Services	Routine	SITE5	Pass	12/18/2020 4:51	2/11/2021 10:36
Ticket7	Cleaning Requests	Routine	SITE5	Pass	12/3/2020 10:44	2/3/2021 14:37
Ticket8	Cleaning Requests	Urgent	SITE5	Pass	2/6/2021 23:29	2/11/2021 14:53
Ticket9	Electrical/Power	Routine	SITE5	Fail	8/25/2020 10:08	2/10/2021 8:31
Ticket10	Cleaning Requests	Urgent	SITE5	Pass	2/6/2021 23:29	2/11/2021 14:53

[v-chuncz-msft]

@ad23 

Instead, you may drag [SLA] to Columns in a Matrix visual.

[ad23]

Thanks for your reply! Ok just tried that. So the 'Pass' field works but for some reason the 'Fails' do not show the data. For example out of 10 tickets for a site, 8 passed and 4 failed. So when I click on 8 it shows me the ticket details for the 8. But when I click on the 2 fails it gives me the ticket details of all 10 for the site.