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.
I'm using the timeline slicer from the gallery. I would like for the default range to have the previous month selected instead of the entire year. Is this doable?
Solved! Go to Solution.
Hi, no this is not possible. If you want a previous month as a default, why not create a calculated column to use as a filter. Assuming you have a date table, something like:
IF (
AND (
Data[Date]
>= DATE ( YEAR ( NOW () ), MONTH ( NOW () ) - 1, 1 ),
Data[Date]
<= DATE ( YEAR ( NOW () ), MONTH ( NOW () ), 1 ) - 1
),
"previous month",
""
)
>>>if this is a solution please mark as such.
Hi, no this is not possible. If you want a previous month as a default, why not create a calculated column to use as a filter. Assuming you have a date table, something like:
IF (
AND (
Data[Date]
>= DATE ( YEAR ( NOW () ), MONTH ( NOW () ) - 1, 1 ),
Data[Date]
<= DATE ( YEAR ( NOW () ), MONTH ( NOW () ), 1 ) - 1
),
"previous month",
""
)
>>>if this is a solution please mark as such.
Thanks. This works great for me.
Andrew
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 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |