Forum Discussion
Custom Date Table slicer causing data to vanish
Community ChampionIt's difficult to debug this at a distance but I can make some general points:
The data is disappearing from the table visual because there will be one or more measures in the visual which evaluate to blank and powerbi then removes those lines. This is standard powerbi behaviour.
Points to investigate: The combination of fields and measures in the visual and the filters applied on the visual. As I stated above, I don't like the model. It would be my starting point for investigation : which fields from which tables are in the visual and how are they affected by filters (from slicers and from the relationships between data tables).
The interaction between slicers (especially from the same table).
You might want to start by reducing the fields in the table visual to only come from the Incident table and try that with one slicer from the date table. It would prove my theory if any fields/measures added to this table visual from the other table go on to 'break' the visual
Sadly I've tested this as well with as minimalist of a dataset before to the same results. Created a new table with simply Name, Client and Created On, and have a single slicer which is only our new Date table and we see the same disappearance of all records:
The majority of the data doesn't have filters applied to it and all tests have been without the other slicers interacting with the table so it should only be filtering by Date.