Forum Discussion

Tome_05's avatar
Tome_05
Helper III
2 years ago

About customizing the date tool

I am always grateful for your help. Regarding the date in the attached image, is it possible to display the day of the week in the date display area? (Or customize, such as making weekends and holi...
Need Help
Tips and Tricks
Tome_05's avatar
Tome_05
Helper III
2 years ago

I am always grateful for your help.

 

Regarding the date in the attached image, is it possible to display the day of the week in the date display area?
(Or customize, such as making weekends and holidays red)

 

Please let me know if there is a way to do it.

thank you.

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Tome_05 

    If you change the Date format and use Dropdown Slicer or Vertical List Slicer inplace of Between with Slider, it will work

     


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

  • danextian's avatar
    danextian
    Super User
    2 years ago

    Hi Tome_05 

    Using the between, before  or after slicer options will not show the name of day. However, it should be available when selecting a day from the calendar icon. Alternatively, you can create measures that return the min and max days based ont he current selection and format it with the day name. As to the list of days, I'd use a table with the date column in it which should dates within the range selected as per the slicer.  I'd use conditional formatting to change the color to red if the date is a holiday. This information should be in your dates table.