cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anshenterprices
Helper III
Helper III

merging cells in table

Source data

CollegeNameClassnoofstudents
ABCFY60
ABCSY80
ABCTY50
XYZst40
XYZnd70
XYZrd30



i want below output but i dont want matrix table

CollegeNameClassnoofstudents

                                     FY          60
  Abc                             SY          80

                                     TY           50
                                    ST            40
XYZ                               nd            70
                                    rd               30
   



1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@Anshenterprices , This best possible in matrix

 

or try

concatenated(Table, Table[Class] & " " & Table[noofstudents],unichar(10))

 

or

concatenated(Table, Table[Class] & " " & Table[noofstudents] & unichar(10))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

3 REPLIES 3
amitchandak
Super User IV
Super User IV

@Anshenterprices , This best possible in matrix

 

or try

concatenated(Table, Table[Class] & " " & Table[noofstudents],unichar(10))

 

or

concatenated(Table, Table[Class] & " " & Table[noofstudents] & unichar(10))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

@amitchandak  I have used the matrix then turned off the row_header stepped layout from the property of matrix and after that i opened all the + icons and then turn off the  +/- Icon from the property of matrix. its sorted finally its looks like simple table now

Hi @Anshenterprices ,

 

As mentioned above, the best way to show the results is to create a matrix visual. If your question has been solved, you can mark the correct response as a standard answer to help the other members find it more quickly.


If the problem is still not resolved, please provide detailed error information. Looking forward to your reply.🙂

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.