Report to show only columns with specific values

Question

Hi,I’ve very new to Power BI.&nbsp;I have a large spreadsheet with staff names down column A, their Line Manger in Column B then lots of questions in column C onwards, around 100 questions from a survey where staff have answered True, False or N/A.I would like a report where the manager selects their name from a filter, then presented with another filtered list of their team members.&nbsp; When they select an individual, I would like it to only display the questions they have answered False or N/A to displayed in a list.&nbsp; The majority of the answers will be true, so I don’t expect to have a large number of False or N/A for most staff but if there are lots they will just have to scroll through the list.I don’t even know if this is possible in Power BI.&nbsp; Any suggestions how to tackle this would be much appreciated.I have included a sample of what the data looks like to give you an idea of what I'm working with.Thank you.&nbsp;NameLine ManagerQuestion 1Questions 2Question 2Questions 3Question 3Questions 4Question 4Questions 5Staff oneManager ATRUEFALSEFALSETRUETRUEFALSEN/ATRUEStaff twoManager BTRUEFALSETRUEFALSETRUETRUEN/AFALSEstaff threeManager BTRUETRUETRUETRUETRUETRUETRUEN/AStaff fourManager CFALSEFALSETRUEFALSEFALSETRUEFALSETRUEStaff fiveManager AN/ATRUETRUETRUETRUEN/ATRUETRUEstaff sixManager AFALSETRUETRUETRUETRUEFALSETRUETRUEstaff sevenManager CFALSETRUETRUEN/AFALSETRUETRUEFALSEstaff eightManager ATRUEN/ATRUETRUETRUETRUETRUETRUEstaff nineManager BN/ATRUETRUETRUEFALSEFALSEFALSETRUE

ribisht17 · Accepted Answer

EleriW&nbsp;
&nbsp;
Use the Unpivot option to solve this problem
Step 1

&nbsp;
Step 2-Rename

&nbsp;
Step 3
&nbsp;

&nbsp;
&nbsp;
&nbsp;
Regards,
Ritesh
Mark my post as a solution if it helped you|&nbsp;Munde and Kudis (Ladies and Gentlemen)&nbsp;I like&nbsp;your Kudos!!&nbsp;!!My YT Channel Dancing With Data&nbsp;!!&nbsp;Connect on Linkedin&nbsp;!!&nbsp;PL 300 Certification Series
&nbsp;

Forum Discussion

Report to show only columns with specific values

2 Replies

Related content

Wrap text in specific columns?

Columns heading when exporting a Report Builder report to CSV

Send specific report content in email

Updating specific columns

Tooltips for specific columns in a table

Name	Line Manager	Question 1	Questions 2	Question 2	Questions 3	Question 3	Questions 4	Question 4	Questions 5
Staff one	Manager A	TRUE	FALSE	FALSE	TRUE	TRUE	FALSE	N/A	TRUE
Staff two	Manager B	TRUE	FALSE	TRUE	FALSE	TRUE	TRUE	N/A	FALSE
staff three	Manager B	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	N/A
Staff four	Manager C	FALSE	FALSE	TRUE	FALSE	FALSE	TRUE	FALSE	TRUE
Staff five	Manager A	N/A	TRUE	TRUE	TRUE	TRUE	N/A	TRUE	TRUE
staff six	Manager A	FALSE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE	TRUE
staff seven	Manager C	FALSE	TRUE	TRUE	N/A	FALSE	TRUE	TRUE	FALSE
staff eight	Manager A	TRUE	N/A	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
staff nine	Manager B	N/A	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE