filter row across multiple columns

[jmchaney]

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! 

[amitchandak · Accepted solution]

@jmchaney , On way is to unpivot the data nad then use it, You will have task and status as columns 

https://radacad.com/pivot-and-unpivot-with-power-bi

[jmchaney]

Thank you....Trying it now.