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.
Example would be Item A, B, C etc is dropdown that we have received certain data. I would like to have the data associated to it to show like this below. All data is coming from SharePoint List data
Item A | |
Data from Columns | |
Data from Columns | |
Data from Columns | |
Item B | |
Data from Columns | |
Data from Columns | |
Data from Columns | |
Data from Columns | |
Item C | |
Data from Columns | |
Data from Columns | |
Data from Columns | |
Data from Columns | |
Item D | |
Data from Columns | |
Data from Columns | |
Data from Columns | |
Item E | |
Data from Columns | |
Data from Columns |
Solved! Go to Solution.
Have you tried a Maxtrix Visual and putting everything in "Row".
@olsen9
Are you expecting you output to be as follows?
Share a dummy set of data that represent your actual data, this could be done in Power Query.
tem A | Data from Columns |
tem A | Data from Columns |
tem A | Data from Columns |
Item B | Data from Columns |
Item B | Data from Columns |
Item B | Data from Columns |
Item B | Data from Columns |
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Actually that's how it's listed now, they want it just like how I have it above. Item A has to be a row header with all the data associated below, then Item B based on alphabetical.
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 |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |