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
Anonymous
Not applicable

Sliding Slicer Single Select?

Hi, I'm hoping to build a sliding slicer that selects only one date at a time. It seems like single-selection is only an option for dropdown/list and not slider. I would like users to be able to toggle to a single date of data (not a sum of before/after/between). Is this impossible? Is there a custom visual I could download to do this? 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Thanks, this is closer. It may be helpful for folks with smaller date ranges, but given the span of years I have, it's a bit unwieldy. I guess I'll just wait and hope PowerBI creates a simple single-select slider!

View solution in original post

5 REPLIES 5
K_Vrushali
Frequent Visitor

Hi 

i would like to ask more about slicer and graphic. As you created a sliding slicer , is it also possible to creat sliding graphic or table? I mean i want that once slicer is closed graphic/table should move to a original point.

andres777
Advocate III
Advocate III

I needed to combine 4 functionalities not found in Date Pickers (at the same time):

  • Select a Single Date
  • Default to Yesterdy's date, no matter when the report is open
  • Allow the user an easy  graphical interface to select other dates for this month, or any other Month or Year in the past.
  • Be able to synchronize ALL Reports Tabs to the selected date in the calendar.

We had many users pushing us (BI Analyts) to come up with a more professional solution that works well and looks good.

 

So I had to write my own custom Visual DatePicker (and go through the steep learning curve to learn all: Node Js, Ms Code, JavaScript, XML Parameters, Syncfusion parameters, Power BI compilation process, Sync calendars, etc) it took me around 2 months or more to come up with something end users would love and accept to use.

 

Since I didn't want to reinvent the wheel, I searched and searched all over to find some source code I could re-use inside Power BI environment. Because Power BI acts and works like a website,  I thought I should look for javascript components.  So I found and purchased the SyncFusion Essential JS 2 libraries, just to use one control, the datePicker, the other 59 controls are available for us to use at another time if we want...

A sample of how their calendar datepicker works in on their demo page... Link

Disclaimer : I don't work for SyncFusion or get paid by them to say these comments, I'm just a frustrated user that wanted a professional solution inside Power BI, which according to most users, should be out by now.

 

Clicking on a Day will select that date, clicking on "May 2020" will allow you to select the Month, and further down, clicking on the "2020" will allow you to select the Year. Very simple, elegant and professional.

 

picking a day ;

image.png

picking a Month

image.png

picking a Year :

pick a yearpick a year

 

This is what mine looks inside Power BI... 

 

It Defaults to Yesterday's date, no matter when you open the report.

 

Users click on the Calendar Icon, and I bring the bookmark Page that contains the 

DatePicker Control.  Allowing them to select ONE, single date.

(I removed some labels from the grid, to protect the inocent :)...)

image.png

image.png

Hope this helps some people...

 

Andres

v-jiascu-msft
Employee
Employee

Hi @Anonymous,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jiascu-msft
Employee
Employee

Hi @Anonymous,

 

I would suggest you try the custom visual Timeline. Please refer to the snapshot below.

Sliding-Slicer-Single-Select

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thanks, this is closer. It may be helpful for folks with smaller date ranges, but given the span of years I have, it's a bit unwieldy. I guess I'll just wait and hope PowerBI creates a simple single-select slider!

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.