Forum Discussion
Problem Using a Date Slicer with a Specific Field
Hi amitchandak,
Thanks for the fast response which help point me to get this item fixed. I was changing the modifiedon field type in the data view but it actually needed to be updated in the Edit Queries section. When looking at the field in the query editor it was set at Date/Time/Timezone. Once I change the data type to a Date in the Edit Queries section the issues was resolved.
Thanks for the assistance in pointing me to a solution.
The kind of stuff can happen when you miss some dates on the calendar. But looking the sample seems like modification on seems have the same range as created on.
is modification on having a timestamp. And not visible because of format. If it does not help. To help you further I need pbix file. If possible please share a sample pbix file after removing sensitive information.Thanks.
Also, you can join both dates with time and use userelation in your formula. Check My Recent Blog where I used two dates
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Hi amitchandak,
Thanks for the fast response which help point me to get this item fixed. I was changing the modifiedon field type in the data view but it actually needed to be updated in the Edit Queries section. When looking at the field in the query editor it was set at Date/Time/Timezone. Once I change the data type to a Date in the Edit Queries section the issues was resolved.
Thanks for the assistance in pointing me to a solution.