Ignoring slicer filters

[tex628]

Hello, 

I have a report where i display last registered sales date per product. Only issue is that when i have datefilters on the sales dates gets filtered aswell showing incorrect dates. 

Does anyone have any advice on how to bypass the date slicer and show the corrected date?

Br,

Johannes

[v-jiascu-msft · Accepted solution]

Hi @tex628,

The solutions depend on your data model. If you use a measure to get the last registered date, you could add one part "ALL('TABLE'[sales date])". Or you can use "Edit interaction".

Best Regards,
Dale

[tex628]

The table included many other columns that needed to be affected by the slicer so and to my knowledge there is no way to have the slicer interact only with a specific column using edit interactions. Either way i managed to work out a dax forumla using the allselected() function so it worked out in the end! 🙂

Br,

Johannes