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.
I need to customize a date filter to select dates from a specified month to a specified month.
For example from drop-down list (February) to drop-down list (June).
I need to select beginning and ending month from a drop-down list each, and not from a slicer.
Is that possible in Power BI?
Thank you.
Solved! Go to Solution.
@Anonymous Or most easiest way is to use the BETWEEN slicer. So, it will give you the range to select between two date range. Easy-Peasy one.
@Anonymous Or most easiest way is to use the BETWEEN slicer. So, it will give you the range to select between two date range. Easy-Peasy one.
@Anonymous , You need to create two slicers, based on independent date tables and use them.
So will have two date tables date1 and date2 with month year and use them in two slicer
new meausre =
var _max =maxx(allselected(Date2), Date2[Date])
var _min =minx(allselected(Date1), Date1[Date])
return
calculate(sum(Table[Value]) , filter(Table, Table[Date]>=_min && Table[Date]<=Max))
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |