Forum Discussion

kellyyaker's avatar
kellyyaker
Frequent Visitor
5 years ago
Solved

Graph Display Changes from PBI Desktop to Shared Report in App

I am having trouble with a graph showing one graph result in my desktop instance and another in the online version. I know it has something to do with the date, as the # leads that shift from January in the Desktop version to February in the online version match up with the count of leads that were all entered on January 31. 

 

This is the desktop version, which shows the Texas region met its goal. We've confirmed this with the data in our CRM, that this is the accurate number.

 

This is the online version once the nightly scheduled refresh is run.

 

I cannot figure out what's causing this to happen and I have not been able to fix it after several attempts. Here are the fields in the bar graph:

Note: The invoked date has a relationship with the "createdon" date in the leads table. 

 

 

Need Help

5 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    5 years ago

    Hi kellyyaker 

     

    Can you confirm that the entire dataset is being updated.

     

    Could you also make sure that you have clicked on the Reset to Default button to make sure no other filters are affecting the data?

     

    And finally what happens if you try and create a new report off the dataset in the Power BI Service, does it have the right numbers?

    • kellyyaker's avatar
      kellyyaker
      Frequent Visitor
      5 years ago

      Hi GilbertQ,

      1. Yes, the entire dataset refreshes using an Odata feed and one web doc (Sharepoint spreadsheet).

       

      2. That's my go-to first step any time a report is giving me trouble. I have reset to default and the results is still inaccurate.

      3. I actually DID create another report off this dataset earlier this year and it has the exact same problem:

      Desktop

      Online

       

       

  • nickyvv's avatar
    nickyvv
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hi kellyyaker,

    the first thing I thought of when you mentioned the month-end, was the different timezone the PBI Service (and thus your report) is in. That's always in UTC, unless you tell it otherwise.

    Reza Rad has a very good blog post about this topic of Solving DAX Time Zone Issue in Power BI, but you can also do it in M with the timezone part of the datetime datatype.