Incorporate multiple columns into one slicer

[DJBAJG]

Probably an easy one but I was't able to fidn the right terminology to search for a good result. I've got 4 calculated columns that return True/False values based on my criteria. What I need is a single slicer that will take into account all criteria columns in the dropdown and filter any visuals based on the Target Field. 

If I drop down the slicer and select Criteria A or C the data in Filter 1  and 3 will be applied to all visuals.

If I drop down the slicer and select Criteria B the data in Filter 2 and 3 will be applied to all visuals.

If I drop down the slicer and select Criteria C the data in Filter 1, 2 and 3 will be applied to all visuals.

Target Field | Criteria A | Criteria B |  Criteria C |

Filter 1           True           Fales           True

Filter 2           False          True            True

Filter 3           True           True            True

I tried using a SWITCH staement but becasue the combinations are not mutually exclusive it didn't work. Only the first criteria met was retuned which makes sense. I spent 3 hours on thisand couldn't do it. Please help!

Thanks. 

[DJBAJG]

Ok, so I went ahead and did this. I copied the table and did the unpivot to the new one and used it in the slicer. The results were not as expected. I had to put two columns from the new table into the slicer to get it to function which made the slicer act like a hierarchy which functions but isn't the desired result. I was hoping to have a sungle selection like a typical slicer.

I've include a copy of the original table and the unpivoted table for reference. - I tried but there's no way to upload an excel file??

I've also inclued a screenshot of the slicer output.

[Ashish_Mathur]

I do not understand your statement but yes, you may have to rewrite some existing measures. 

[Ashish_Mathur]

Hi,

4 fields cannot be displayed in a single slicer.  You will have to rewrite your DAX calculated column formulas in the Query Editor (to get the TRUE/FALSE) and then Unpivot your data so that all TRUE/FALSE appear in a single column.

[DJBAJG]

The columns were already in TRUE/FALSE form. See the screenshots below. What am I missing?

Original Table:

New unpivoted table:

[Ashish_Mathur]

Hi,

There should be 2 slicers - one for Attribute and another for Value.