Data value changes when published

[sraj]

Hi,

This has never happened before with me, not sure what may be causing this.  For some reason when I publish this report the data for 2022 is just completely changing the value.  This is happening due to my incremental refresh, all I am doing is 11 years of archive and 15 days of refresh.  

Original

Published one 

 

This is what derives the above value:

Pro Max = MAXX('Combined Table', [Total PCount])

OR THIS

MAX = MAXX (VALUES( 'Combined Table'[dtd]), [Total PCount] )

Total PCount =

SUM('Combined Table'[o_prot_cnt]) + SUM('Combined Table'[a_prot_cnt])

  +  

Can someone please advise?

[sraj · Accepted solution]

Finally this is what helped

= [dtd] => RangeStart and [dtd] < RangeEnd

Before I was doing the =>RangeStart and [dtd] <= RangeEnd which was causing the duplication I guess.  Found an article that helped me fix this.  

[sraj]

I checked all the above suggestions and it is still the same.  To be specific the publised data looks like the desktop but when it is refreshed on the web the value changes.

Is there any other way for me to present this sum?

I need to show the total of two columns for that day that year ( would be any year selection) .

126235 (o_prot_count) + 367493 (a_prot_count) = 493728

[Anonymous]

Hi @sraj ,

What happens if you click on the Reset to default button?

Also can you ensure that you have got the last version of PBI Desktop installed?

Then open the file, save it and upload it again and see if that resolves your issue?

I have also found a similar psot, please refer to it to see if it helps you.

Data Values Changing after publishing - Microsoft Power BI Community

• you can go into the properties for the chart and set the Y Axis start to Zero as shown below

If it still does not help, please provide more details.

Best Regards

Community Support Team _ Polly

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