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 d...
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

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

      • ppei's avatar
        ppei
        Regular Visitor
        8 years ago

        Maggie,

         

        I am sorry that I didn't reply soon. I was busy resolving the problem. The problem is not due to Power BI. It is due to our source data. The logs are configured in a facility monitor software and then generate logs in SQL. For some reasons SQL stopped generating reports for a couple of days so I cannot get all last 7 days' data in Power BI. We have resolved the problem. Your suggestion to use visual filter is very helpful. Thank you for your help.

         

        Pei