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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
PowerRon
Post Patron
Post Patron

How to force to select one or more options from slicer?

Hi,

 

I simplified the problem. Having a report page with two slicers, Year slicer and Period slicer. And a matrix containing date and number of transactions.

In the first figure I select a year, 2022, and a period, December peak, and it is showing me the dates in that December peak.

knip1.JPGIn the second figure I select a year, 2022, and a no period. It is showing me the dates available for 2022 as well as that December peak. Be aware, in my dataset there was no data for May peak, otherwise it would have shown here as well.

 

knip2.JPG

 

What I would like is the folowing:

  • If I don't select a period in the period slicer, it will show me all peak periods. But not the remaining data as well (see figure 2, year 2022 Sep/Oct/Nov) OR
  • I force the user to select at least one peak period

 

How do I do that (in an easy way) ?

regards
Ron

 

1 ACCEPTED SOLUTION
PowerRon
Post Patron
Post Patron

Option would be to hide the period slicer as long as no peak period is selected

View solution in original post

2 REPLIES 2
PowerRon
Post Patron
Post Patron

Option would be to hide the period slicer as long as no peak period is selected

lbendlin
Super User
Super User

I force the user to select at least one peak period

That is pointless as in Power BI "Nothing selected"  is equivalent to "All Selected"  (with some nuances that are not important here)

 

Quick fix:  Make the Period slicer single select.

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!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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.

Top Solution Authors
Top Kudoed Authors