Slicer selection then filter columns on value

[gmjd1]

I am trying to create a power BI visul to help me identify which training modules a specific job role will need to complete.

The original data in Excel contains a job title column, and then various columns with module titles and Y & N's in each column under these modules next to the relevant job titles.

I have a table that contains various module titles, and either a Y or N to mark this module as relevant yes or no.  I then have a slicer that allows me to choose a job title, and in turn displays the Y & N's for the selected job role. 

What I am hoping to do however, is when a job role is selected in the slicer, the table can be set to only display the columns that contain a Y, so I have a list of relevant modules for this selected job role. Is this possible please I cannot find how to do this?

I did also attempt to replace the N values to blanks but still been unable to stop it showing these blank columns. Any suggestions are appreciated.

[gmjd1]

Thanks for the replies. I have not been able to get it to work still unfrotunatley, but this may be my lack of Power Bi skills meaning I am doing something wrong.

Here is a sample of the data:

And then my visual is a table, using a slicer to select the job role seen in column 1, and hoping to make this only display the columns containing a Y then in the table and the N's excluded. Any help is appreciated.

[Anonymous]

Hi @gmjd1 ,

I suggest you to try to create a measure to filter your visual.

Filter =
IF ( MAX ( [Y or N] ) = "Y", 1, 0 )

Add this measure into visual level filter and set it to show items when value = 1.

If this reply still couldn't help you solve your issue, please share a sample file with me.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@gmjd1 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Check if these features and use of selected value of field parameters can help

Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf

How to create a dynamic Axis using a slicer? https://youtu.be/RblNR5yeF8Y