Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi community! I need to filter a date column by a selected value on the report of an other date column, which is a date too.
I´ll be more especific, I have:
*Date Column 1, wich can be filter by the user on the report. User can choose only one value.
*Date Column 2: This is the date column that I need be filtered. I need that it shows only the dates before the selected value in Date Table 1.
How can I solve it? Any idea?
Thanks!
Solved! Go to Solution.
Hi @mmazzalay ,
Please create a measure and add it to the filter on the visual.
Measure =
IF(
MAX('Date Table 2'[Date]) > SELECTEDVALUE('Date Table 1'[Date]),
1, 0
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @mmazzalay ,
Create 2 slicers one each for your both date columns.
Now click on first date slicer and go to edit interactions and check if the 2nd slicer has filter option enabled.
Once this is done, whenever you select a data range in your 1st date slicer, 2nd slicer will show date range based on the selection.
Something like this:
For setting up edit interactions in Power BI, refer following article:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Thanks,
Pragati
Thank you for your help, but it doesn't solve the issue.
I need that if on the first filter (Date Report) the user select 29/5/2020, the second filter (Periods) only shows the dates after 29/5/2020.
Hi @mmazzalay ,
Please create a measure and add it to the filter on the visual.
Measure =
IF(
MAX('Date Table 2'[Date]) > SELECTEDVALUE('Date Table 1'[Date]),
1, 0
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @mmazzalay ,
Make your Periods slicer a date range slicer like I have in my screesnhot.
Also are your date columns (both) are of DATE datatype or string?
Thanks,
Pragati
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 |
---|---|
109 | |
102 | |
85 | |
78 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |