Reply
olsen9
Frequent Visitor
Partially syndicated - Outbound

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 
1 ACCEPTED SOLUTION
Tom_Y
Advocate II
Advocate II

Syndicated - Outbound

Have you tried a Maxtrix Visual and putting everything in "Row".

Tom_Y_0-1702049764578.png

Tom_Y_1-1702049794275.png

 

View solution in original post

3 REPLIES 3
Tom_Y
Advocate II
Advocate II

Syndicated - Outbound

Have you tried a Maxtrix Visual and putting everything in "Row".

Tom_Y_0-1702049764578.png

Tom_Y_1-1702049794275.png

 

Fowmy
Super User
Super User

Syndicated - Outbound

@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

olsen9
Frequent Visitor

Syndicated - Outbound

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.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)