topic Re: Group the data by semesters in HTML & CSS viewer in Power BI in DAX Commands and Tips

Group the data by semesters in HTML & CSS viewer in Power BI

Natia — Tue, 25 Apr 2023 09:26:01 GMT

Hello everyone, I need your help.

I downloaded HTML & CSS viewer in Power BI Desktop and I try to write a DAX code in it.
I can write a code for semesters and for courses separately but I could not put the courses according to their semesters to show what courses a student have passed in concrete semester.
I could reach only this visual at this moment using these formulas below:

<tr >

<td>Course Name</td>

"& CONCATENATEX(DISTINCT('Courses'[Semester ID ]), "<tr> <td ></td> <td align='center'>"& 'Courses'[Semester ID ],,'Courses'[Semester ID ],ASC)&"

"&CONCATENATEX(FILTER('Courses','Courses'[Semester ID ]='Courses'[Semester ID ]),"<tr> <td ></td> <td align='center'>"& 'Courses'[Course Name ] &"</td> </tr>","",'Courses'[Semester ID ],ASC) &"

</tr>

I want to achieve this result instead of visual I created above:

If it is not enough information here, I can send you a Powe BI example file with mail.

Thank you so much in advance,

Re: Group the data by semesters in HTML & CSS viewer in Power BI

lbendlin — Sun, 30 Apr 2023 00:18:10 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Group the data by semesters in HTML & CSS viewer in Power BI

irinabazghadze — Sun, 30 Apr 2023 11:40:21 GMT

Thank you for your replying,

This is working example file:

https://drive.google.com/file/d/1ufv1gLffwnK2KQXoh9imoh3e5z7knP8J/view?usp=sharing

I need to sort students subjects by passed semesters.

what I made is:

but i need semester id 38 in group (when subject is several).

So, My goal is to achive this result:

this task is very important for us.

thank you for your attention

topic Re: Group the data by semesters in HTML &amp; CSS viewer in Power BI in DAX Commands and Tips

Group the data by semesters in HTML & CSS viewer in Power BI

Re: Group the data by semesters in HTML & CSS viewer in Power BI

Re: Group the data by semesters in HTML & CSS viewer in Power BI

topic Re: Group the data by semesters in HTML & CSS viewer in Power BI in DAX Commands and Tips