Reply
Topic Options
- 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
12-08-2023
06:45 AM
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.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-08-2023
07:37 AM
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-08-2023
07:37 AM

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
12-08-2023
06:51 AM

@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 |
Did I answer your question? Mark my post as a solution! and hit thumbs up
⭕ 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
12-08-2023
07:31 AM

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
Recommendations
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 |
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
89 | |
82 | |
53 | |
40 | |
35 |