Forum Discussion

Pier14's avatar
Pier14
New Member
2 years ago
Solved

Filtering based on selection from slicer

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!!!

 

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    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 .

     

     

     

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    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 .