Automate Grouping

Question

Hello guys, I'm currently working with a big workbook file which has an attribute field that has to be grouped by product. The only problem is that there is also other information in the field and when I click on new Group I would have to indivially group it all by myself.

Is there anyway to automize that wiht a measure or something? I need the groups for a matrix visualization.

Thanks in advance!

amitchandak · Answer

Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
&nbsp;
You can create a measure or use groups - https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning

anonymous · Answer

It looks something like this:&nbsp;Type&nbsp; &nbsp; &nbsp; &nbsp; Attribute&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;StatePhone&nbsp; &nbsp; &nbsp;&lt;Text&gt; iPhone 6s&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;activePhone&nbsp; &nbsp; &nbsp;iPhone 11 &lt;Text&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;activePhone&nbsp; &nbsp; &nbsp;&lt;Text&gt;&lt;Text iPhone 6s &lt;Text&gt;&nbsp; active

Forum Discussion

Automate Grouping

2 Replies

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Automated refreshes

Community User Group Experience

Automating API link updates

PowerBi and Power Automate