Forum Discussion

devgian's avatar
devgian
Frequent Visitor
2 years ago

SLICER SINGLE SELECTION MONTH DAY

Hi Everyone, 

Good day! 

I have a slicer dropdown with selection Year, Month Day. However I don't want user to be able to select multiple month and multiple day. 

As you can see in the image below when clicking 2024, you are selecting all months. If you hit January your selecting all days. I don't want to select all. 

 



CalendarTable: 

 

DimCalendar = 
VAR BaseCalendar = 
    CALENDAR (DATE (2023, 1, 1), DATE (2024, 12, 31))
RETURN
    ADDCOLUMNS (
        BaseCalendar,
        "Year", YEAR([Date]),
        "Month Number", MONTH([Date]),
        "Month Name", FORMAT([Date], "MMMM"),
        "Day", DAY([Date]),
        "Day of Week Number", WEEKDAY([Date]),
        "Day of Week Name", FORMAT([Date], "dddd"),
        "Week Number", WEEKNUM([Date])
    )

 




Is there a way on this? Thanks!

General Comment
Need Help

2 Replies

  • AnkitaaMishra's avatar
    AnkitaaMishra
    Super User
    2 years ago

    Hi devgian ,

    Not sure if I have understood the problem clearly but tried replicating the same.
    All you need to do is expand the slicer values and click on only one day which will not select others day for that particular month.

    Please provide additional information if I have misunderstood anything. 



    • devgian's avatar
      devgian
      Frequent Visitor
      2 years ago

      Hi AnkitaaMishra , 

      Thanks for your response. 

      But I think, the best way I can explain is that. 
      1. When you select example 2024 it will be January by Default, if you click January it should be day 1 by default