Filtering Issue - Power BI Desktop

[hsparg008]

I have a dashboard that's showing the time stopped for different test rooms. The data in Power Query (pictured) has a row for each day and each test room with multiple status updates per day. This is summed to determine the time stopped and why the room was stopped. 

When a reason from the "reason stopped" chart is selected, the dashboard includes the time in setup, time testing, and time open in the calculations since it was in the same row (pictured), so it incorrectly shows a utilization of above 0%. Additionally the time in setup/teardown and in testing are greater than 0. 

Is there a way to fix this filtering --  so when a "reason stopped" is selected, the dashboard filters to only show stopped time?

[hsparg008 · Accepted solution]

I added additional filters to the "Why Did Testing Stop?" chart, and this fixed the issue. 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523