Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
bmcminn
Helper II
Helper II

Dynamic default slicer selection

Hello. These values are not attached to an actual date, so I am not sure how to have the default slicer selection update when the report is refreshed. Any help is appreciated.


image001.png

image002.png

3 REPLIES 3
olgad
Super User
Super User

You can make a slicer with the visual filter set to top n by whatever latest 5 academic periods or to top 5 periods  by revenue depending whats the requirement


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
olgad
Super User
Super User

Hi, you cannot make dynamic selection in power bi unless you give your selection a generic name. Lets say I always want the current month to be selected by default, then I have to create a column where i would say the month of today ="Current Month". Once current month is selected, the selection will remain after refresh. 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Thanks, that's what I though. One thing I am trying to do is make a measure that is a list of the top five values in the ACADEMIC_PERIOD column. Power BI wants me to use the TOPN filter for that, but I'm wondering if I have a list in a measure, could I use that list for the slicer?

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.