Forum Discussion
Combined Booleans In Slicer
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?
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" etcInstead of IF statement you can also use SWITCH functionThen add this new column as a slicer
4 Replies
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
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" etcInstead of IF statement you can also use SWITCH functionThen add this new column as a slicerThanks 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!
Im glad it worked amart2
Please make sure to accept it as solution as it will help other users as well
