Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
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.
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
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.
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?
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 80 | |
| 40 | |
| 31 | |
| 27 | |
| 27 |