Additional Slicer options which don't exist in the data

[PaulBoden]

Hi all,

Encountered an odd one I was hoping someone might shed light on.

I have a slicer thats using a custom month and week field (shown below). The filter is working as expected but I notice that the slicer is showing five weeks for every month, including those with only four. Selecting this doesn't display any data, but I'm not sure where the slicer option is coming from in the first place.

SSs below:

  

Any suggestions as to what's causing this and how I can best resolve?

Thanks in advance.

[lbendlin]

Look at the data tab, or look at the result of the Power Query code. Check if the P08 W05 value is truly absent.

[PaulBoden]

Yes, I have. The first image is actually from the data tab. Week 5 doesn't exist in the data.

[lbendlin]

Check if "Show items with no data" is enabled.  Show a sanitized version of your data model.

[PaulBoden]

Already unselected 🤔

[lbendlin]

Please show a sanitized version of your data model, or maybe share a sample pbix.