Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Community!
I'm having a play with some data in PowerBI Desktop, I have a large number of columns with percentage data in (0% - 100%) stored as number (not a decimal).
When I plot this as a bar chart it, naturally, shows all percentages. I can group these into 10's using a fairly cumbersome tool.
Is there an easier way than having to define all my own groups? We're talking a couple of hundred columns here.
Thanks.
Solved! Go to Solution.
Hi @Ruksuro,
It's confusing, you have a couple of hundred columns, how did you display it in bar chart? If you want to category many columns to several groups, it impossible in Power BI desktop. If you want to group different values in same column, you can right click the field->group, set it based on your requirement. More details, please review this article.
Best Regards,
Angelia
Sorry, the confusion is my fault, I was unclear.
I would like to group the values within each column individually (for example bands of 10%).
The interface for creating groups in drag and drop by each unique value, it would take a while to do all columns.
Thanks for your help, it's a shame this is not a feature.
When you deal with fields with high cardinality the grouping tool is fairly unuseable.
I'll set up some processing in DAX.
Cheers.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |