Forum Discussion
New filter experience - remove trailing counts?
Hi Anonymous，
Based on my research, I am afraid you could not achieve this feature currently, I suggest you submit an idea in ideas forum:
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Daniel He
I tried changing the the field type from Edit queries and it worked. no more count of.
Hi, could you provide some details on what you did? We have the counts happening on all types of fields - text, integer, etc. If you can explain I'd really appreciate it - thanks!
Scott
Basically, on Power Bi, its actually seeing all column as Text. it has to be converted to decimal for it to do a sum(column)
on your data pane,
Click "Edit Queris"
Then right click on the column you want to change type,
Look for "Change type" then select decimal number or any other numeric format.
then click "close and apply"
you will see a sum symbol in front of your column on power BI. then try that on your values.
Hi, that's not quite the issue I'm running in to. See screenshot below - we have text based dimension values, and I'm trying to suppress the count after those.
Thx,
Scott
Anonymous
I would like to know as well how you achieved this actually?
Regards