date hierarchy showing future value

[Anonymous]

hi guys

i have a data which from jan 2024 up to jan 2025

when i use date hierarchy so inserct slicer it shows me a slicer from jan 2024 to december 2025 ( when actually there is no data there in my table )

kindly assest me to remove the extra month from my slicer ( keep in mind that on monthly basis i am updating this visual.  so after on month i will be showing Feb data then march... etc )

notice:  there is no any other table in my visual or relationhships 

[PhilipTreacy]

@Anonymous 

The data you have shown is not dates, it's one column of numbers and one column of text.  PBI will ot recogise tese as dates so you need to create/use a proper date column, preferably in a date table.

You can then use the dates for the slicer.

Please supply your data file if you need further assistance.

Regards

Phil

[rohit1991 · Accepted solution]

Hi @Anonymous ,

Fix: Remove Extra Future Dates from Slicer in Power BI

Your slicer shows future months because of Auto Date/Time Hierarchy or a disconnected Date Table.

Solution 1: Turn Off Auto Date/Time

1. Go to File > Options and Settings > Options
2. Under Data Load, uncheck Auto Date/Time
3. Refresh your model

Solution 2: Filter the Slicer

1. Select the Month-Year slicer
2. In the Filter Pane, add a condition:
   • Show only existing months from the data table

Solution 3: Use a DAX Filter

Create a measure to show only months with data: HasData = IF( COUNTROWS( 'YourTable' ) > 0, 1, 0 )

• Apply it as a visual-level filter
• Set HasData = 1