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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
centroid
Helper I
Helper I

slicer - no options in settings of visual available for date range

I have a created a slicer visual. Unfortunately I cannot create a date slider. When I put the date hierarchy (Year/Quarter) into the data field of the visual, and then go into slicer settings, I cannot activate the options, but only slider selection appear, which returns check-boxes, but not a slider. If  I only enter Year into the data field, then a slider option is available, but then I can only check years, but no other date ranges. Can you help?

1 ACCEPTED SOLUTION
krishb1414
Helper III
Helper III

Hi @centroid , If your Date column has heirarchy then by default you will heirarchy format while using that column in slicer. 
If you see the images below :
  1) by default choosing heirarchy
  2) select your date column instead of date heirarchy ( see in image 2 )
  3) Now, it will all date values in list format then select drop down icon and you will options as in imgae 3.
  4) Finally slect "Between" option from drop down then you will able to see the date as range format.


krishb1414_0-1681978356938.pngkrishb1414_1-1681978498475.png

krishb1414_2-1681978625743.png

Thanks

View solution in original post

1 REPLY 1
krishb1414
Helper III
Helper III

Hi @centroid , If your Date column has heirarchy then by default you will heirarchy format while using that column in slicer. 
If you see the images below :
  1) by default choosing heirarchy
  2) select your date column instead of date heirarchy ( see in image 2 )
  3) Now, it will all date values in list format then select drop down icon and you will options as in imgae 3.
  4) Finally slect "Between" option from drop down then you will able to see the date as range format.


krishb1414_0-1681978356938.pngkrishb1414_1-1681978498475.png

krishb1414_2-1681978625743.png

Thanks

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors