Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

date hierarchy showing future value

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 

 

 

Need Help
  • rohit1991's avatar
    rohit1991
    1 year ago

    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

     

2 Replies

  • rohit1991's avatar
    rohit1991
    Super User
    1 year ago

    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

     

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    1 year ago

    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