March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
Solved! Go to Solution.
Hi, @BDIAZCUSI
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
Hi, @BDIAZCUSI
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
36 | |
27 | |
19 | |
11 | |
8 |
User | Count |
---|---|
55 | |
43 | |
25 | |
13 | |
12 |