locked
Date select not working right RRS feed

  • Question

  • HI,

    I'm new to Power BI. I had a dashboard that only pulled current day's data. Worked fine in power bi.

    I changed the query to go back three months (from date). That works in power bi , but when I move the slider to June (for example) I get no records even tho there is June data in my results.

    I have attached a screenshot I hope will help. I have added my fromdate and todate to both page and report filters. Still won't show any data unless I include the march..? 


    If I change the data selector to just june - I get nothing eventho there are June records 


    qeqw


    • Edited by rqwew Friday, June 17, 2016 4:41 PM
    Friday, June 17, 2016 4:33 PM

Answers

  • It's hard to answer your question with only a screenshot of the report. What does your model looks like?

    If you take both 'From Date' and 'To Date' from the same table, you're filtering this single table on two mutually exclusive values which would cause the report to go blank. But that's just a first guess.

    Tuesday, June 21, 2016 7:22 AM
    Answerer