Combined Booleans In Slicer

[amart2]

Hello,

I have rows from a table that I want to filter in Report based on if they are labeled as Rejected/Reloads/Restarts.  I envision this as a box with each of them listed, where you can check off which ones you want filtered (checkmark = true).  It doesn't seem like you can combine them in a slicer, and I can only do them individually as True/False.  Is there a way I can get them listed together instead?

[themistoklis · Accepted solution]

@amart2

Creating a new column (not measure) may help in your case but generally combining fields in one slicer is not supported on PowerBI.

New Column = IF(Sheet1[Rejected] = TRUE(), "Rejected", IF(Sheet1[Month] = TRUE(), "Reload" etc

Instead of IF statement you can also use SWITCH function

Then add this new column as a slicer

[amart2]

Thanks @themistoklis, that was exactly what I needed!

To clarify, I had three seperate boolean columns, and I wanted the option to which ones I wanted to filter in one slicer.  So creating that combining column allowed me to do that, thanks again!

[themistoklis]

Im glad it worked @amart2

Please make sure to accept it as solution as it will help other users as well

[v-cherch-msft]

Hi @amart2

I cannot fully understand it. Could you share some sample data or explain more about your expected output? Maybe you may check SELECTEDVALUE Function and HASONEVALUE Function if they could help you.

How to Get Your Question Answered Quickly

Regards,

Cherie