Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |