Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi there,
What do I need to do when I open a dashboard by default the current year has to be selected.
Thank you.
You can use relative date slicer instead of Tile, so that eaisly you can able to set current year by default, when ever you can open repots/dashboards it will automatically select that..
please let me know if it is useful to you....
@giofranc , As of now, you have use work around of the new column with this year. I have seen update over Linkedin that this feature will be released soon
Year Type = Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)
Save on this year
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 46 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |