Forum Discussion

ppei's avatar
ppei
Regular Visitor
8 years ago
Solved

Filter for Timestamp Column not Working

I am totally new to Power BI. I was asked to create a dashboard for energy use based on trendlogs. I only want to show one week's data so I tried to use data filter "in the previous 7 days". But it didn't work for me. My dataset still show all the data back several months. I suspect that my timestamp column's date/time format caused the issue. The format for the column includes date and time (date, month, year, hour, minute, and second). Does anyone have similar issues? Do you have any suggestions how to resolve the issue?

 

Thanks in advance.

 

Pei

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi ppei

    I can't reproduce your problem, could you try the filter in the Table View by adding relus in the Visual Filter?

    Or could you share your pbix to me via private message?

     

    Best Regards

    Maggie

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    Hi ppei

    How do you apply the filter to timestamp column?

    May be you can share an example file with me and I can test for you to find the problem.

    I make a test on my site, but it works well for me.

     

    Best Regards

    Maggie

    • ppei's avatar
      ppei
      Regular Visitor
      8 years ago

      Maggie,

       

      Thank you for your help. I don't know what happened the other day. I tried today and it works. However, the result is not what I want. I want previous 7 day's data. which I put in my filter, but I only get 2 day's data. See my screenshots below. Do you have any suggestions?

       

      Thanks,

      Pei

       

       

       

       

       

       

       

       

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        8 years ago

        Hi ppei

        I can't reproduce your problem, could you try the filter in the Table View by adding relus in the Visual Filter?

        Or could you share your pbix to me via private message?

         

        Best Regards

        Maggie