Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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:
If it is not enough information here, I can send you a Powe BI example file with mail.
Thank you so much in advance,
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-...
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
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 11 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 19 | |
| 12 | |
| 11 |