In line chart i want my y axis as original values as my variable, my x axis is timestamp

[Anonymous]

so here in y axis i want original values so that i can see that how my pattern is  In excel it is giving original but my data is in lacs so i want in my powerbi to this values as original. plz help i have to submit my work today

[Thingsclump · Accepted solution]

Hi @Anonymous 

I am not sure if I completely understand the question but still I will try to give an answer. This is just to help you with your work completion today.

If possible, go to Powerquery editor and check the numbers that you see. Is it from 1 to 30 or is it 100000 to 300000? If possible please share a screenshot of what you see. Again remove senstive information please before sharing.

second alternative. If you are referring to values on Y axis, select the chart and then go to format. Expand Y axis section and change display units to none. Now values which are shown as .5, 1, 1.5 etc should show with complete digits.

Thanks

www.thingsclump.com

[Thingsclump · Accepted solution]

Please check the values field. You will see a small drop down in the values field. Click on it and see the aggregation.

May be default aggregation is selected as sum. 

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

I have encountered a similar case, your case should be caused by the same reason.

All in all, the problem is caused by the existence of multiple different values for the same datetime.
The reason for the peak in PowerBI is that the same datetime appears multiple times in the sample data and PowerBI adds up the values for the same datetime, in Excel, it seems to only use the value for a particular datetime. This is where the problem arises. In some ways, PowerBI seems to handle the data more rigorously.

Refer:

Sudden peaks in stacked area chart plotting PowerBI visuals

Best Regards,
Community Support Team _ Zeon Zheng

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

[Thingsclump · Accepted solution]

Hi @Anonymous 

I am not sure if I completely understand the question but still I will try to give an answer. This is just to help you with your work completion today.

If possible, go to Powerquery editor and check the numbers that you see. Is it from 1 to 30 or is it 100000 to 300000? If possible please share a screenshot of what you see. Again remove senstive information please before sharing.

second alternative. If you are referring to values on Y axis, select the chart and then go to format. Expand Y axis section and change display units to none. Now values which are shown as .5, 1, 1.5 etc should show with complete digits.

Thanks

www.thingsclump.com

[Anonymous]

So can you see that highest spike has value 3.18 but it's coimg between 15 to 20 that is wrong. I'm doing this on powerbi . I also changed Display auto to none still the axis is same

[Thingsclump · Accepted solution]

Please check the values field. You will see a small drop down in the values field. Click on it and see the aggregation.

May be default aggregation is selected as sum.