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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
harshadrokade
Post Partisan
Post Partisan

Slicer management

I have two slicers coming from single table.

 

Slicer 1- Student name

Slicer 2- Date

 

When I select a Student name & the Date slicer is auto filtered & shows only those dates applicable to selected Student. Now user cant select any other Student from Student slicer until the user selects 'All' in Date slicer. 

 

E.g. If St1 is selected & Date 23-12-22 selected, I cant see St2 and St3 in Student slicer as Date 23-12-22 is not applicable for St2 or St3. Then I need to select 'All' in dates slicer & after that it shows me all Student names. This is impacting the user experience. 

 

If I disable the interaction of these two slicers then the problem is  if someone selects a student name & date in slicer & selects any other Student name, the entire dashboard goes blank as the selected new Student name & date cmbination doesnt exist.

 

Student nameDate
St123-12-22
St124-12-22
St125-12-22
St226-12-22
St227-12-22
St228-12-22
St329-12-22
St330-12-22
St331-12-22
St301-01-23
5 REPLIES 5
LP280388
Resolver II
Resolver II

@harshadrokade when you have a date slicer from date table which allows for continous dates instead of showing discontinued dates from your original table , it shows all the dates and the user can select the range of dates instead of selecting one date at a time. removing interaction from Students slicer to this Date slicer will make sure that the dates are not filtered and always available for the user to choose the dates.   the Students slicer which still has interaction from Date slicer which show only the students present in that date range.

This is not a solution to your problem, but another way of approaching. 

djurecicK2
Super User
Super User

Hi @harshadrokade ,

 I would start by adding a separate date table if you don't already have one.

https://radacad.com/do-you-need-a-date-dimension

 

Thanks for the reply @djurecicK2 I cant have seperate date table as then it will not get filetered when I select Student name. I want to show only those dates to the user which are applicable to thr selected Student name. Having seperate date table will show all dates to the user in Date slicer & user willl not be aware which dates are applicable to the selected Student

@harshadrokade ,

 

Having a Date Table is the right way to go always. If you think you shouldn't have date table, then my suggestion is to use the filter pane instead of slicers.  This doesnt solve your problem but gives the user an understanding that the selected student or a date has a value in other column or not as shown below with 0 as value.

LP280388_1-1671788097499.png

 

 

@LP280388 @djurecicK2  I am unable to understand how can a seperate Date table help me here? Are you talking about a delinked seperate table which will not get impacted by any value selection in Student name table?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors