Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a column in a table called 'submission date' and using the date hierarchy I have added a 'filter by quarter' slicer. I want the slicer to have a default selection of the current quarter but if the user selects other quarters then the visuals should filter accordingly. Is there a way to do this?
@aar1 , As of now you have to use a workaround
A new column like this and save on this Qtr
Switch( True() ,
format(today(), "YYYY - \QQ") = format([Date], "YYYY - \QQ"), "This Qtr",
[Qtr Year]
)
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |