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.

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

Hi Maryann ,


How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

 

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

Yours works fine.   But mine does not. So I must not have something set correctly. Still working on it.

thanks