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

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.