Forum Discussion
Solved
Creating date slicer removes data
Problem - when creating a "Date" slicer for information in my visual, I lose data from a table I have set up. Example: Setting up a slicer based on the Date table, you can see there is a range t...
v-hashadapu Thanks for your help.
I would consider this resolved. I can transform the data that is pulled into the model from DirectQuery as well. This is suitable for my needs.
It turns out that changing the table from DirectQuery to Import still didn't do what I needed it to do.
I deleted the table from the model and reloaded it, this time transforming the order Date column to short date format.
This transform was able to get rid of the underlying time stamp format for me.
Hi raschdieek , Thanks for the update and providing the details. We are really happy to know that your issue is resolved now. If you have any other queries, please feel free to create a new post, we are always happy to help.