Grouping

Question

Hi,I have watched a few tutorials online on how to group resuts in PowerBI.In this situation I have over 1000 individual customers. I want to group their results in BINS however when I try to the only Group Type option available is List? It won't allow me to select BINS.&nbsp;How can i change this? Do i need to change the data format or something?&nbsp;Thanks,Andy

ribisht17 · Answer

hi andykbba&nbsp;
&nbsp;
When you say "bin" basically that will act on measure/quantitative not qualitative.
&nbsp;
Like Sales,Profit etc. Bins is not for qualitative fields like customer names
&nbsp;
Regards,
Ritesh

andykbba · Answer

Hi ribisht17&nbsp;,Thanks for your response. It is quantitative data that I am wanting to group. Could it be the amount of data? Is there a limit how much can be grouped or not really

ribisht17 · Answer

Please check the data-type
&nbsp;
Is it text ? Then you need to change the same to number

&nbsp;
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning 
&nbsp;
&nbsp;

Forum Discussion

Grouping

3 Replies

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Community User Group Experience

User Group Leader Get Started Guide

FAQ on the Fabric User Groups

Groups