Forum Discussion
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!
jmchaney , On way is to unpivot the data nad then use it, You will have task and status as columns
2 Replies
- amitchandakSuper User
jmchaney , On way is to unpivot the data nad then use it, You will have task and status as columns
- jmchaneyRegular Visitor
Thank you....Trying it now.