Forum Discussion
All statistics greyed out in Power Query
I am trying to perform a count of values in a text column. The statistics button is greyed out in both the Transform and Add Column tabs. It will not allow me to perform counts for non-numeric columns.
All other statisitic functions work as expected for numeric data.
Is this a settings issue?
This appears to be a glitch associated with the setting Options > Global > Report Settings > Customize Appearance.
Setting this option to anything other than "Legacy" causes this glitch along with others including disabling the Power Query quick-access toolbar.
I've already placed some feedback and you may want to as well:
5 Replies
- OwenAuger
Super User
This appears to be a glitch associated with the setting Options > Global > Report Settings > Customize Appearance.
Setting this option to anything other than "Legacy" causes this glitch along with others including disabling the Power Query quick-access toolbar.
I've already placed some feedback and you may want to as well:
ryan_mayuDo you want to create a new column? what's the expected output?
No, I just want to create an aggregate statistic of the count of values or count of distinct values for a text column. The statistics button is greyed out for any text column I select. I can create a count or count statistic value for a numeric column, just not a text column. This was working and has stopped since I updated PowerBI
- ryan_mayu
you can try to use group by function in PQ
https://learn.microsoft.com/en-us/power-query/group-by?wt.mc_id=DP-MVP-5004616
If this still can not solve your issue, pls provide some sample data and expected output.