Forum Discussion
New filter experience - remove trailing counts?
Hi, I'm playing with the new filter experience - which I like in general, but having an issue I can't figure out how to solve. After each entry in a individual filter, it seems to give a count of how many times that value shows up in the data. That might be useful for filters directly on a fact table - but when you filter on dimension tables, it either returns a "1" for every row because you're querying a leaf-level dimension value, or returns a number at "parent" dimension values which makes absolutely no difference to end users. I don't want my "Product Category" filter to show 27 after category ABC...because that 27 just means the value showed up 27 times in the dimension table, which NO one cares about (ever).
Is there a way to turn off the trailing number? It takes up a decent amount of space and makes it much more difficult to read the values.
Thanks,
Scott
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
9 Replies
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
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.