Forum Discussion

slan2018's avatar
slan2018
Frequent Visitor
4 years ago
Solved

Slicer is missing months

Hello,

I am using a slicer that uses a field DateMonth from an Excel sheet. Data for January-March 2022 has been loaded into the sheet and is showing in the PowerBI Data section, but I do not see January 2022, February 2022, or March 2022 as options in my slicer. Any thoughts as to why I would be missing those dates from the slicer?

 

 

 

 

  • Hi slan2018 ,

    I think there are certain filters that are affecting these values. Check if there are any filters applied on the slicers by clicking the funnel icon on the slicer header.

     

    Please accept this as a solution if your question has been answered !!

    Appreciate a Kudos ğŸ˜€

2 Replies

  • Hi slan2018 ,

    I think there are certain filters that are affecting these values. Check if there are any filters applied on the slicers by clicking the funnel icon on the slicer header.

     

    Please accept this as a solution if your question has been answered !!

    Appreciate a Kudos ğŸ˜€

  • jaipal's avatar
    jaipal
    Resolver III

    slan2018 can you check the data column is used in the DateMonth slicer? Looks like you used another colum