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

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