Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
How to display current year and month to be selected in the slicer (i.e. would automatically open on the current month at all times).
Solved! Go to Solution.
@Umadhandapani , There is only work around for that
Year Type = Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)
Month Type = Switch( True(),
month([Date])= month(Today()),"This Month" ,
month([Date]) & ""
)
or
Month Type = Switch( True(),
Date([Date]) = eomonth(Today(),-1),"Last Month" ,
Date([Date])= eomonth(Today(),0),"This Month" ,
[Month]
)
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
You need save value like this year, this month
@Umadhandapani , There is only work around for that
Year Type = Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)
Month Type = Switch( True(),
month([Date])= month(Today()),"This Month" ,
month([Date]) & ""
)
or
Month Type = Switch( True(),
Date([Date]) = eomonth(Today(),-1),"Last Month" ,
Date([Date])= eomonth(Today(),0),"This Month" ,
[Month]
)
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
You need save value like this year, this month
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |