Forum Discussion

Nobody1292's avatar
Nobody1292
Regular Visitor
4 years ago

Filter 2 columns

Hi,

I am looking for a way or visual to search across 2 columns in the dashboard.

So I have in column A project names and in column B developer group 1 and in C developer group 2.

I would now like to be able to search for names that can be in both B or C.

Does anyone have any ideas for me?

Many greetings
Nobody

2 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional

    Hey Nobody1292 ,

     

    you could create a hierarchy in the slicer and then search for both developer groups.

    Would that work for you?

     

    Otherwise the following approach from SQLBI should work:

    https://www.youtube.com/watch?v=UvvS376vYSw

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up ?

    Best regards
    Denis


    Blog: WhatTheFact.bi
    Follow me: twitter.com/DenSelimovic

    • Nobody1292's avatar
      Nobody1292
      Regular Visitor

      Hi, 

      thank you

      "you could create a hierarchy in the slicer and then search for both developer groups"

      But then I have to select the desired entry several times in the slicer, depending on the combination in which it occurs, right?