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,
I've a viz with a slicer based on Year with mandatory single selection:
Since data are continuosly flowing into the report, and data are visualized considering a single year at time I would to have that filter automatically showing the "highest" value as default. Is it possible?
Thanks in advance
Bruno
@Br1-981 , As of now you have use a work around, The feature is in progress as per various posts
If(Date[Year] = year(Max(Table[Date]) ) , "Max Year" , Date[Year]&"")
And save this on Max year
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
Thanks for your feeback it is not so clear to me how to use it, is it a new column or measure?
How do you use it as a slicer?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |