Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Everybody !
I'm new to power BI and so i'm trying to filter a table based on a slicer
I have a [Date added] for the data and i want to select only rows where the date difference between [date added] and today
Here's the dax query that i came up with so far :
Filter= IF(VALUE(DATEDIFF('Extraction devis organisation'[Date added].[Date];TODAY();DAY)) >= MIN(Slicer[SLICER Selection]) ; "O";"N")
and on the filter panel i select only rows with "O"
The slicer table has no relationships with other tables and yet it doesn't work
Does anyone have a clue why
Thany you
@Gueray wrote:
Hello Everybody !
I'm new to power BI and so i'm trying to filter a table based on a slicer
I have a [Date added] for the data and i want to select only rows where the date difference between [date added] and today
Here's the dax query that i came up with so far :
Filter= IF(VALUE(DATEDIFF('Extraction devis organisation'[Date added].[Date];TODAY();DAY)) >= MIN(Slicer[SLICER Selection]) ; "O";"N")
and on the filter panel i select only rows with "O"
The slicer table has no relationships with other tables and yet it doesn't work
Does anyone have a clue why
Thany you
So I guess that the Filter = is an expression for a calculated column, right? Slicer works on visual level, it can't effect calculated column/table which based on source data. In summary, calculate column/table has Pretreatmented before selected on slicer, instead of calculated column, try to apply a filter expression to your measures.
measure = CALCULATE ( [yourMeasureHere], FILTER ( 'Extraction devis organisation', TODAY () - MIN ( 'Extraction devis organisation'[Date added] ) >= MIN ( Slicer[SLICER Selection] ) ) )
[yourmeasurehere] what do you mean by it because in my example i didn't introduce any measure
Thank you
@Gueray wrote:
[yourmeasurehere] what do you mean by it because in my example i didn't introduce any measure
Thank you
You could replace the measure like SUM('yourtable'[yourColumn])
I did what you said but unforunately it didn't work do you have any other method ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |