Fields are not populating in slicer

[Anonymous]

For some reason all the fields are not populating in my slicer. I ensured that there aren't any other competing slicers that are causing any issue. I have attached images below. Essentially what I did was combine a list of excel files into a single dataset through Power Query. The excel files are named after the date that they were produced. I ended up converting the filename into a date field so that I can see the changes between datasets over time. For this example I have 4 fields/sets that I should be able to filter through:

However when I go to the report view to select the different dates i see this:

These are the filters active on this page/report:

I'm not sure why this is happening. I have done this process once before it worked perfectly fine, and it did exactly what I expected it to do, but for some reason in this report it is not cooperating. Any help would be appreciated

Thanks,

Squanch

[Anonymous]

Hi @Anonymous ,

Are your 4 fields the last step in applied steps? Please check your applied steps.

Or it may be because you have performed a filtering operation in Filters and the date disappeared. Try to clear all the filters to see if the date exists.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Redraidas1]

Have you checked how relationships have been set up between your tables? Perhaps there's a relationship that's filtering out some rows from your table that contains your interval dates? 

[Anonymous]

Thanks for the response, I just checked the relationships, and the relationships seems to be in the right order.