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 ,
I am having 2 slicer in Report First is for Year and Second Slicer is for Month Name
First Slicer like below data
2014
2015
2016
Second Slicer having data like below
January
February
March
April
Here requirement is when user open pbix file that report should display Max Year and Max Month by default in both slicer visual.
How to handled that using DAX. Please guide me because in normal Slicer there no any such property to set default Max Year or Max Month
Solved! Go to Solution.
@Anonymous,
You may deal with it in a similar way as described in link below.
https://community.powerbi.com/t5/Desktop/Default-Behavior-Date-Filter-to-Most-Recent/td-p/235337
@Anonymous,
You may deal with it in a similar way as described in link below.
https://community.powerbi.com/t5/Desktop/Default-Behavior-Date-Filter-to-Most-Recent/td-p/235337
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 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |