Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good morning,
is there anyway that I can set a page level filter to a report and use a column as a part of the filter.
I'm trying to filter by year dinamically, so this year I'll have year 2020, 2021 and 2022 but next year I would like to have 2021, 2022 and 2023 without changing the filter every time
thanks for your help
@IvanDP , You need create a column like this you date table/table
Switch(True() ,
[Year] >= year(Today()) -2 && [Year] >= year(Today()) , "Last three year"
[Year]
)
You can save page on last three year
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |