Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create New Filter With OR option between to columns

Hi Gurus, 

I'm New with power bi and I have an issue with filtering a Table. 

I want the user to be able to filter de report like this. 

 

Select Fields

from Table t

where t.Date1 = "Date selected on filter1"

OR t.date2 = "date selected on filter 2"

 

Currently I'm not being able to create a data Slicer or a filter in the report that could do this with an OR condition.

 

Do any one have an idea if I'm missing any functionality or component?

 

This is what I need to achieve. 

As you can see, the fields that start with "FECHA" are dates as an internal code. But this is the result I need. 

I filter FECHA_VCTO1_C1 = 33035 OR FECHA VCTO1_C2 = 33035

 

Please, let me know if I'have to be more specific.

 

Regards

Need Help
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    Please make the following changes in your original pbix:

    1.create seperate tables for field 'FECHA_VCTO1_C1' and field ‘FECHA VCTO1_C2 ’

    calculated table:

    slicer1 = VALUES('Table'[FECHA_VCTO1-C1])
    slicer2 = VALUES('Table'[FECHA_VCTO1-C2])

    2. add a measure as below and apply it to visual filter pane

    filter = 
VAR condition1 =
    IF (
        MAX ( 'Table'[FECHA_VCTO1-C1] ) = SELECTEDVALUE ( 'slicer1'[FECHA_VCTO1-C1] ),
        1,
        0
    )
VAR condition2 =
    IF (
        MAX ( 'Table'[FECHA_VCTO1-C2] ) = SELECTEDVALUE ( 'slicer2'[FECHA_VCTO1-C2] ),
        1,
        0
    )
RETURN
    IF ( condition1 + condition2 > 0, 1, 0 )

    Best Regards,
    Community Support Team _ Eason

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    Hi, Anonymous 

    Please make the following changes in your original pbix:

    1.create seperate tables for field 'FECHA_VCTO1_C1' and field ‘FECHA VCTO1_C2 ’

    calculated table:

    slicer1 = VALUES('Table'[FECHA_VCTO1-C1])
    slicer2 = VALUES('Table'[FECHA_VCTO1-C2])

    2. add a measure as below and apply it to visual filter pane

    filter = 
VAR condition1 =
    IF (
        MAX ( 'Table'[FECHA_VCTO1-C1] ) = SELECTEDVALUE ( 'slicer1'[FECHA_VCTO1-C1] ),
        1,
        0
    )
VAR condition2 =
    IF (
        MAX ( 'Table'[FECHA_VCTO1-C2] ) = SELECTEDVALUE ( 'slicer2'[FECHA_VCTO1-C2] ),
        1,
        0
    )
RETURN
    IF ( condition1 + condition2 > 0, 1, 0 )

    Best Regards,
    Community Support Team _ Eason