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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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