Custom Slicer functionality

[allen00se]

Hello,

I have a table of data that has many columns where each column uses either a 1 or 0 to represent if that row of data has that columns specific type of error. 

DIRNumber is the PK of the record, every other column is a potential type of error. 

I would like to have a slicer where I can select different types of errors and it would filter the table looking at the column for a value of 1.

In the example above I would like to select "IL2" from the slicer and have only rows where the column IL2=1

Is this possible? If so I would appreciate a nudge in the right direction, I have already created a table which holds all of the error codes to populate the slicer.

Thanks in Advance!

[amitchandak]

@allen00se , You can consider field parameter.

Or unpivot all error code in Power query

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Learn Power BI: Power Query Table.Unpivot, Table.UnpivotOtherColumns: https://youtu.be/0FEGEAz9UMw

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
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