Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |