Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
@Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
You can create a measure or use groups - https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning
It looks something like this:
Type Attribute State
Phone <Text> iPhone 6s active
Phone iPhone 11 <Text> active
Phone <Text><Text iPhone 6s <Text> active
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |