Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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 name | Date |
St1 | 23-12-22 |
St1 | 24-12-22 |
St1 | 25-12-22 |
St2 | 26-12-22 |
St2 | 27-12-22 |
St2 | 28-12-22 |
St3 | 29-12-22 |
St3 | 30-12-22 |
St3 | 31-12-22 |
St3 | 01-01-23 |
@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.
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
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 @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?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
89 | |
83 | |
75 | |
49 |
User | Count |
---|---|
142 | |
140 | |
110 | |
69 | |
55 |