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.
Hi
Does anyone know if its possible to create a Months Between Slicer. e.g Jan-2022 to Feb-2022 . The relative date option is not good enough as you cannot select different months, just current minus x no of months.
Timeline slicer on app store is along right lines but is massive and takes up to much space.
thanks
Solved! Go to Solution.
Hi @zausten ,
If there is only one date table, then I think you have to use the multi-select feature of the slicer.
If you are willing to try two separate date tables, then you need to use the measure to filter the data.
Measure =
COUNTROWS (
FILTER (
'Table',
'Table'[Date] >= MIN ( Dates[Date] )
&& 'Table'[Date] <= MAX ( 'Dates 2'[Date] )
)
)
Best Regards,
Winniz
Hi @zausten ,
If there is only one date table, then I think you have to use the multi-select feature of the slicer.
If you are willing to try two separate date tables, then you need to use the measure to filter the data.
Measure =
COUNTROWS (
FILTER (
'Table',
'Table'[Date] >= MIN ( Dates[Date] )
&& 'Table'[Date] <= MAX ( 'Dates 2'[Date] )
)
)
Best Regards,
Winniz
You can use two disconnected tables to feed individual slicers, and then use a measure as a page filter to enact the month range.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |