Forum Discussion

sraj's avatar
sraj
Responsive Resident
3 years ago
Solved

Data value changes when published

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?
 
 
Need Help
  • sraj's avatar
    sraj
    3 years ago

    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.  

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

  • sraj's avatar
    sraj
    Responsive Resident
    3 years ago

    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

     

     

  • sraj's avatar
    sraj
    Responsive Resident
    3 years ago

    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.