Date Range Slicer - Limit to Month Selection

[AmyD]

Hi All,

I'm looking at this downloaded visual. Does anyone know how to limit the user selection - for the 'from' range, to only be able to select the 1st of the month, and for the 'to' range to be only able to select the end day of the month.

Many thanks

[AmyD]

Thanks very much 🙂

[SamInogic · Accepted solution]

Hi,

Current Limitation

The Date Range Selector (custom visual) does not support restricting user selection to specific days like:

• Only 1st of the month for From
• Only end of month for To

This kind of constraint is not available out-of-the-box in that visual.

Recommended Workarounds

Option 1 – Use a Month-Level Slicer (Best Practice)

Instead of daily dates, create a Month column in your Date table:

YearMonth = FORMAT('DateTable'[Date], "YYYY-MM")

Then:

• Use this field in a slicer
• Change slicer type to Between or Dropdown

This ensures users select full months only

Option 2 – Use Start/End of Month Columns

Create helper columns:

StartOfMonth = STARTOFMONTH('DateTable'[Date])
EndOfMonth   = ENDOFMONTH('DateTable'[Date])

Use these fields in slicers so users naturally pick valid boundaries.

Option 3 – Enforce via Measure (Soft Restriction)

You can validate selection and show results only when valid:

Valid Selection =
IF(
    DAY(MIN('DateTable'[Date])) = 1 &&
    DAY(MAX('DateTable'[Date])) = DAY(EOMONTH(MAX('DateTable'[Date]),0)),
    1,
    0
)

Then:

• Use this as a visual filter = 1
• Or show a message like “Please select full months only”

Option 4 – Use Built-in Relative Date Slicer

If applicable:

• Use Relative Date slicer
• Set to Last X Months

Automatically ensures full-month logic

Best Practice

For scenarios like yours, most implementations:

Avoid day-level slicers
Use Month/Year hierarchy slicers

This improves:

• User experience
• Performance
• Data consistency

Hope this helps.

Thanks!