Forum Discussion

Maryann's avatar
Maryann
Icon for Helper I rankHelper 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
Icon for Community Support rankCommunity 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
    Icon for Helper I rankHelper I
    6 years ago

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

  • Maryann's avatar
    Maryann
    Icon for Helper I rankHelper 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
      Icon for Helper I rankHelper 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

      • v-lid-msft's avatar
        v-lid-msft
        Icon for Community Support rankCommunity 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.