Visuals won't be showing "Actual Value" even if type=number

[ThoVez]

Hello everybody, 

For my current project I am fetching my data through an API (I dont know if this could be causing the issue)

I just want to plot a Y value with a name on the X axis.
Even if the Y value is actually number, the plot will only propose sum/average/count etc.

I think I've seen lots of unresolved cases for this problem so I'll try my luck.

Is there something I am missing ? 

Intead of just having the value for each X element...

Thanks a lot, have a good day

[ThoVez]

If someone can have a look at this issue

[v-xiaotang]

Hi @ThoVez 

Thanks for reaching out to us.

What chart are you using? and I'll check it later

Best Regards,

Community Support Team _Tang

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

[ThoVez]

Hi Xiao,

Basically any bar chart won't be displaying the right values.

Thanks for taking care! 

[v-xiaotang · Accepted solution]

Hi @ThoVez 

Thanks for your reply.

That is by design, when you have multiple duplicate values on the x-axis, the line chart will aggregate their corresponding values. As a workaround, you can try the solution shared by  Bapaknyaanak2  who have asked the same question.

"

I think i've found how to make Power BI shows the actual value, instead of aggregate in line chart. In my case, it's solved by creating a slicer, and i just need to drag the column that I interested in seeing it as an actual value to it. Then, my line chart will show the actual value.

In @v-haibl-msft's example, he can make it like that because it only has one value and once the X-axis data appear twice in the column (which is my case), then power bi started to show it as aggregate.

" 

link: Solved: How to show value instead of aggregate - Microsoft Power BI Community

Best Regards,

Community Support Team _Tang

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