- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Building a Table and showing Data based on a column as a Row
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Have you tried a Maxtrix Visual and putting everything in "Row".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
02-20-2024 12:24 PM | |||
03-03-2024 02:45 AM | |||
04-16-2024 06:57 PM | |||
08-26-2024 03:42 AM | |||
01-05-2024 05:56 AM |