Forum Discussion

Lindino08's avatar
Lindino08
Frequent Visitor
2 years ago

Desktop visual different than Service

I have a line graph I created that is using a measure to calculate the cumulative amounts for the year based on order date. I just added in our new fiscal year. Copied the measure I created from the others and changed the measure to our new fiscal year, just like all the others have. The visual in desktop works and looks exactly how it is supposed to, but when I published it the visual is not the same. 

Desktop version: (Correct One)

 

Service Version: (Wrong)


Any idea what could be causing this?

 

 

Need Help

3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    Lindino08 

    Click on the applied filter Button on the header of the visuals and check if the same filters are applied. It could be that an additional filter is causing this.


  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Lindino08 

     

    When a Power BI report behaves differently in Power BI Desktop versus after being published to the Power BI Service, it could be due to a few reasons. Here are some steps to troubleshoot the issue:

     

    1. Refresh Data: Make sure that the data in Power BI Service is refreshed after publishing. Sometimes, the report may not reflect the latest changes until a manual or scheduled refresh is done.

    2. Check for Errors: After publishing, check for any errors or warnings in the dataset or reports in the Power BI Service. Sometimes measures might not calculate as expected if there are issues with the underlying data model.

    3. Review Relationships and Model: Ensure that all relationships and the data model are intact and that they replicate the same structure as in Power BI Desktop.

    4. Version Compatibility: Make sure you are using the latest version of Power BI Desktop. Older versions might not be fully compatible with the current Power BI Service.

    5. Check Measures: Double-check the DAX formula for the measure you created for the new fiscal year. Ensure that it is referencing the correct columns and that any filters or context transitions are applied correctly.

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.