Forum Discussion

jbrinker's avatar
jbrinker
Frequent Visitor
6 years ago
Solved

Problem Using a Date Slicer with a Specific Field

Hi,   For some reason I am struggling getting a slicer to be used with a specific date field.  I have deleted most items from my data model so I am left with a pretty simple model.  I have a Calend...
Need Help
  • jbrinker's avatar
    jbrinker
    6 years ago

    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.  

amitchandak's avatar
amitchandak
Super User
6 years ago

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

 

jbrinker's avatar
jbrinker
Frequent Visitor
6 years ago

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.