Forum Discussion

sona_b's avatar
sona_b
Frequent Visitor
2 years ago
Solved

How to merge 2 columns into one filter

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...
Need Help
  • uzuntasgokberk's avatar
    uzuntasgokberk
    2 years ago

    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 |

uzuntasgokberk's avatar
uzuntasgokberk
Icon for Super User rankSuper User
2 years ago

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 |