The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All
Is it possible to lock a Relative Date Slicer to Weeks only rather allow the user to change the period?
And if not is there some other solution to allow the user to toggle for their own choice of weeks only?
Solved! Go to Solution.
Hi @derekmac
The slicer cannot only choose the week, but maybe you can refer to the follwing solution to substitue it.
Sample data
1.Create a number paramater to set it as last week slicer
2.Then create a measure
Measure =
VAR a =
SELECTEDVALUE ( Parameter[Parameter] )
VAR b =
MAXX ( ALLSELECTED ( 'Table 2'[Date] ), [Date] ) - 7 * a + 1
RETURN
IF (
SELECTEDVALUE ( 'Table 2'[Date] ) >= b
&& SELECTEDVALUE ( 'Table 2'[Date] )
<= MAXX ( ALLSELECTED ( 'Table 2'[Date] ), [Date] ),
1,
0
)
3.Then you can create a visual and put the data to the visual, then put the measure to the visual filter(e.g table visual)
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I now this is already solved but I'm offering an alternative solution for those who might search and find this thread.
https://www.villezekeviking.com/dax-tables-calendar-and-time/
I have offset-columns from today that can be used to filter any report relative from today on days, weeks, months, quarters or years.
Unlike the relative date filtering, this can span any period, from historical data, over current periods and into the future.
Hi @derekmac
The slicer cannot only choose the week, but maybe you can refer to the follwing solution to substitue it.
Sample data
1.Create a number paramater to set it as last week slicer
2.Then create a measure
Measure =
VAR a =
SELECTEDVALUE ( Parameter[Parameter] )
VAR b =
MAXX ( ALLSELECTED ( 'Table 2'[Date] ), [Date] ) - 7 * a + 1
RETURN
IF (
SELECTEDVALUE ( 'Table 2'[Date] ) >= b
&& SELECTEDVALUE ( 'Table 2'[Date] )
<= MAXX ( ALLSELECTED ( 'Table 2'[Date] ), [Date] ),
1,
0
)
3.Then you can create a visual and put the data to the visual, then put the measure to the visual filter(e.g table visual)
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |