Line chart Broken after publishing

[SadStatue]

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:

Status	Dates	Total Staff
Forward	Friday, 24 July 2020	1
Forward	Friday, 24 July 2020	1
Forward	Friday, 24 July 2020	1
Forward	Friday, 24 July 2020	1
Forward	Thursday, 23 July 2020	1
Forward	Thursday, 23 July 2020	2
Forward	Thursday, 23 July 2020	1
Forward	Thursday, 23 July 2020	1
Forward	Thursday, 23 July 2020	2
Forward	Thursday, 23 July 2020	2
Forward	Thursday, 23 July 2020	1
Forward	Thursday, 23 July 2020	2
Forward	Thursday, 23 July 2020	1
Forward	Thursday, 23 July 2020	1
Past	Friday, 17 July 2020	1
Past	Friday, 17 July 2020	1
Past	Friday, 17 July 2020	1
Past	Friday, 17 July 2020	1
Past	Friday, 17 July 2020	1
Past	Friday, 17 July 2020	1
Past	Friday, 17 July 2020	1
Past	Friday, 17 July 2020	1
Past	Friday, 17 July 2020	1
Past	Friday, 17 July 2020	1
Past	Thursday, 16 July 2020	2
Past	Thursday, 16 July 2020	3
Past	Thursday, 16 July 2020	3
Past	Thursday, 16 July 2020	2
Past	Thursday, 16 July 2020	2

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

[v-lionel-msft]

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]

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]

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.

[SadStatue]

Yes it is solved after I re-structured my data model and measures.

But I don't know what was the main problem

[amitchandak]

@SadStatue , Have tried clear cache and refresh?

[SadStatue]

Hi Amit

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