Filtering based on selection from slicer

[Pier14]

Hi there -

I have a data set that flags different criteria using true/false in 4 different columns.

For example

High Repairs - True/False 

High Age - True/False

High Downtime - True/False

High Usage - True/False

In my power bi dashboard, I am trying to create a slicer that allows the user to pick one of these 4 different flags and only return the TRUE value from these columns.  

I have been stuck on this for days.  I tried creating a parameter based on selected value,  but I don't know how to get it to return only TRUE.  Any insights would be greatly appreciated!!!

[ryan_mayu · Accepted solution]

@Pier14 

you can do the data transform in PQ

1. select those 4 columns and unpivot columns

then unselect false in the value column

then you can drag attribute to the filter visual. when you select the value under attribute , you will get all true values .