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.
Hi.
In SharePoint Document Library, you can create views. But sometimes those views dont go far enough. I have a library with several columns that need groupings..... This view for PowerBI has 8 main columns..... I would like to create a view to:
Group by Business Type (Type A, Type B, Type C, Type D). This is the Parent....
Then it has 5 columns that serve as children. These columns group on same type per the column choices....
1.) Group By Department 1
2.) Group By Department 2
3.) Group By Department 3
4.) Group By Department 4
5.) Group By Department 5
Im trying to 1.) determine which PBI widget to use. Maybe the table or the matrix. but i would like a collaped arrow that user can click on to see all "like" items GROUPED pending which column chosen (Parent or one of the children). Can someone tell me how to do this and the DAX (if needed) to use?
thank you in advance
Use the Matrix visual. No DAX needed.
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 |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |