Forum Discussion

Maryann's avatar
Maryann
Helper I
6 years ago
Solved

Or Condition on filter

How can I allow the user to select what date they want to see the data filtered by , depending on 2 columns:

Select data where date A = value (or range) or Date B = value (or range)

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Maryann ,

     

    We can archieve your requirement in single visual if you mean the two columns are in the same table. Firstly we create two calculated table based on the two columns:

     

    FilterColumnA = 
DISTINCT('Table'[Date A])

     

    FilterColumnB = 
DISTINCT('Table'[Date B])

     

    Then we create a measure to filter the visual:

     

    isDataFiltered =
COUNTAX (
    'Table',
    IF (
        OR (
            [Date A] IN FILTERS ( 'FilterColumnA'[Date A] ),
            [Date B] IN FILTERS ( 'FilterColumnB'[Date B] )
        ),
        1,
        BLANK ()
    )
)

     

    Then we can put it into the visual filter then set it is greater than zero.

     

     


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

6 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Maryann ,

     

    We can archieve your requirement in single visual if you mean the two columns are in the same table. Firstly we create two calculated table based on the two columns:

     

    FilterColumnA = 
DISTINCT('Table'[Date A])

     

    FilterColumnB = 
DISTINCT('Table'[Date B])

     

    Then we create a measure to filter the visual:

     

    isDataFiltered =
COUNTAX (
    'Table',
    IF (
        OR (
            [Date A] IN FILTERS ( 'FilterColumnA'[Date A] ),
            [Date B] IN FILTERS ( 'FilterColumnB'[Date B] )
        ),
        1,
        BLANK ()
    )
)

     

    Then we can put it into the visual filter then set it is greater than zero.

     

     


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Maryann's avatar
      Maryann
      Helper I
      6 years ago

      Thank you!  I'll try it out ,and reply later today.

    • Maryann's avatar
      Maryann
      Helper I
      6 years ago

      I'm new to powerbi, and I'm not sure exactly how to follow your instructions.

      You said to "create two calculated tables"  -  Is that in Modeling -  New table? 

      When I do that I get:    1 TABLE =    

      (not sure where FilterColumnA goes)  

      If you could provide more direction it would be appreciated.

      thanks

      • Maryann's avatar
        Maryann
        Helper I
        6 years ago

        sorry, i didn't realize you sent an attachemnt.  That helps alot.  You can disregard previous question. I'll let you know if I need help.

        thanks