Forum Discussion

SadStatue's avatar
SadStatue
Helper II
6 years ago

Line chart Broken after publishing

Hi All,

 

I have a line chart shows the required staff which coinsist of two measures (one shows the past days and the other shows the future)

the chart works correctly in the PowerBI Desktop as below

when I publish the report still the chart is correct but as fast as I refresh the data in the web service the chart broken and dates corrupted as below!

measures are claculated as below:

CALCULATE(SUM('Refined - all'[Total Staff]),FILTER('Refined - all','Refined - all'[Status]="Past"))
CALCULATE(SUM('Refined - all'[Total Staff]),FILTER('Refined - all','Refined - all'[Status]="Forward"))
 
and "Refind - all" table structure is as below:
 
 
StatusDatesTotal Staff
ForwardFriday, 24 July 20201
ForwardFriday, 24 July 20201
ForwardFriday, 24 July 20201
ForwardFriday, 24 July 20201
ForwardThursday, 23 July 20201
ForwardThursday, 23 July 20202
ForwardThursday, 23 July 20201
ForwardThursday, 23 July 20201
ForwardThursday, 23 July 20202
ForwardThursday, 23 July 20202
ForwardThursday, 23 July 20201
ForwardThursday, 23 July 20202
ForwardThursday, 23 July 20201
ForwardThursday, 23 July 20201
PastFriday, 17 July 20201
PastFriday, 17 July 20201
PastFriday, 17 July 20201
PastFriday, 17 July 20201
PastFriday, 17 July 20201
PastFriday, 17 July 20201
PastFriday, 17 July 20201
PastFriday, 17 July 20201
PastFriday, 17 July 20201
PastFriday, 17 July 20201
PastThursday, 16 July 20202
PastThursday, 16 July 20203
PastThursday, 16 July 20203
PastThursday, 16 July 20202
PastThursday, 16 July 20202
 

I would be glad if anyone can help why the chart changes after publishing

Need Help

6 Replies

    • SadStatue's avatar
      SadStatue
      Helper II
      6 years ago

      Hi Amit

      Yes I cleared the cash and tried different browsers but still have the problem

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi SadStatue ,

     

     

    Check the data in your dataset. Maybe your visual is correct, but the refreshed data does not meet your expectations.

     

    Best regards,
    Lionel Chen

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

    • SadStatue's avatar
      SadStatue
      Helper II
      6 years ago

      Hi v-lionel-msft 

       

      Thats my problem Im quiet sure my visual is correct and when I refresh it trough the Desktop app it works perfectly, but after publishing and refreshing in the web the chart will breaks

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support
        6 years ago

        Hi SadStatue ,

         

        Has your problem been solved?

        Does the latest data from the data source make this problem after you refresh?

         

        Best regards,
        Lionel Chen

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