Forum Discussion

jmchaney's avatar
jmchaney
Regular Visitor
5 years ago
Solved

filter row across multiple columns

Hello

Only month of experience using Power BI but i'm hooked. So far i have solved many problems on my own but i have one i can not figure out.  I have a Sharepoint List to manage Project Tasks and Status.  This specific project consists of 45 station names and 25 unique Tasks. User will update each task with status (Ok, NOT OK, Ongoing, Not Started, NA). Example data 

 

Station Name     Task 1              Task 2            Task 3  

Station #1           OK                  NOT OK         NOT STARTED 

Station #2           ONGOING      NOT OK         OK 

Station #3            NOT OK        OK                  NA

 

Goal:  From reporting standpoint, we want to be able to select single station OR multiple stations and see results of the Tasks based on the Status criteria. For example lets say I wanted to see Station #1, #2, and #3, and NOT OK. Report result should look like 

 

Station Name     Task 1              Task 2            Task 3  

Station #1                                  NOT OK         

Station #2                                  NOT OK         

Station #3          NOT OK                          

 

Thank you in advance for your help!