How to add multiple column headings as rows in Matrix visual?

[gnitha]

Hello, I need to create multiple groups of courses to check completed and incomplete status for each course.

Need to add the colum heading for each course with course name. I'm attaching the sample of the report, how it should look in Power BI. I'm new to Power BI its my first report. Appreciate any help on this.

Thanks so much in advance.

best,

gnitha.

[gnitha]

Hi Ashish, I was able to figure out by myself and completed the report.

Thanks though for taking the time to help me.

best,

gnitha

[Ashish_Mathur]

Hi,

Share the source data in a form that can be pasted in an MS Excel file.

[gnitha]

How do I send the csv files? There is no option to upload the files. Thanks so much🙏

[Ashish_Mathur]

Upload the file to Google Drive and share the download link.

[gnitha]

Here is the link

https://drive.google.com/drive/folders/1rBYR4N-uVjp_QQUFlc7cuFXj0HQIGSlL?usp=sharing

thanks so much:)

[Ashish_Mathur]

Hi,

Has this problem been resolved?  Also, i notice that in the Student data file, in the last 2 columns, while some entries are date and time stamps, some are text entries.  That will have to be cleaned up so that all entries there become proper date/time stamps. 

[Ashish_Mathur]

How should one calculate the figures of 'Students Accessed' and 'Student Completed'?  Please explain.

[gnitha]

Forgot to mention that the Totals column shows number of students that "In Progress" or "Completed" as 'Students Accessed' and 'Student Completed' per course. Thanks

[gnitha]

I've added a picture to the google drive of my Power BI report that I've worked on so far.

I need to update the table on the left with the courses. Thanks

[gnitha]

It should show as 'Student Completed" when the student has a "Completed" status in the CompletionStaus column in the StudentCourseInforamtion table. and similar for 

'Students Accessed' when the CompletionStatus is "In Progress" . Thanks

[gnitha]

Its a simple data. Each highlited one is a course and the rows under each course are 

Students Accessed - course in progress

Students Completed - course completed

Data form main table which is student_course_completion table  which has courseid and course table has course name and courseid. Data from these 2 tables.

thank you,

gnitha

[gnitha]

Hello Ashish, if you can provide your email address I can send the data csv files. Thanks.

[Ashish_Mathur]

I will not create a dataset for you.  Please create it yourself and share it here (in a format that can be pasted in an MS Excel file).

[gnitha]

I was getting error when I try to paste as a table.

thanks.

[gnitha]

Tried several times to send data but I'm getting an error.