How to change the aggregation from Sum to Count in the Card or Any other visual ? (In updated PBI)

[Ganesh_B]

I used to work with powerbi seamlessly before in the older version, but now in the new update when the visual went on top I find difficult to change the aggregation in the charts. For example: from Sum to Count & First to Count etc. If someone give me a solution to my problem, that would be more helpful. Thanks in advance

[Ganesh_B]

Hey @Legend_11 , Thanks for your help.

 I know about the older version & I want how they are changing in the newer version as its very complicating one?

[Ganesh_B]

Hi @rubayatyasmin Thanks for you prompt help, I appreciate it and unchecked to go back.

But I still want to know how the new users are overcoming this issue as maybe if I want to work in the newer version, how I can change the aggregation?

[rubayatyasmin]

HI, @Ganesh_B 

if you click in your visual you will see 2 icons. click first icon. then under the data field click on the > sign. there you will see aggregation. below screenshot will helo. 

[Ganesh_B]

Mine don't have that option 😕 don't know how to fix 😞

[rubayatyasmin]

try this one. expand the visual type. 
before try turning on suggest a type. (should not be a problem, but still we never know)

restart pbi then see. 

if my assistance helped you in any way, hit 👍.

[Ganesh_B]

Thanks for assistance on suggesting to go back to the previous version 👍
But sadly the newer one doesn't work even after trying the multiple ways!

[rubayatyasmin · Accepted solution]

did you try uninstall then install from microsoft store? then try turining on the on-object interaction if not checked. 

[Ganesh_B]

Thanks for your simple and problem solving support @rubayatyasmin 

[rubayatyasmin]

hey, @Ganesh_B 

If you want to go back to previous UI, you can change it from the settings>> preview features>> on-object interaction. just uncheck it, and then restart. 

mine is unchecked already. 

[Legend_11]

you can use this small dropdown and select the required aggregartion.

Hope it helps!