How to merge 2 columns into one filter

[sona_b]

Hi all, let's say I have simple data like this, for each project I have column Active (Y/N) and Important (Y/N).

Is it possible to add 1 single filter (not slicer) to the filter panel that would have options: Active (where Active = Y), Important (where Important = Y) and None? So basically combine the 2 columns into 1 filter. Thank you!

[uzuntasgokberk · Accepted solution]

Hello @sona_b,

Create a new column that contanate Active and Important columns with "-". So the results will be like "Y-Y", "Y-N" , "N-Y", "N-N". And right, now you can filter into single column because you concanate two columns.

Or, the efficent way to solve problem is unpivot your active and ımportant columns, your attribute column values are Active and Important and Values column values will be "Y" and "N". So you can filter in Values column.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |