Grouping of Metrics Automatically

[Ruksuro]

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.

[v-huizhn-msft]

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

[Ruksuro]

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.

[v-huizhn-msft · Accepted solution]

Hi @Ruksuro,

Untill now, we can only create the group manully, can not do it automatically. You can also group by in Query Edit navigator. Please review this artcile for reference.

Best Regards,
Angelia

[Ruksuro]

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.

[v-huizhn-msft]

Hi @Ruksuro,

You can create a feature request here.

Best Regards,
Angelia

[Ruksuro]

Thanks again.

For anyone else with this problem I have submitted my idea here.