Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
This should be simple, Im just going mad, have watched youtube videos and still no luck.
I want one of two things, I suspect the solution is similar either
A simple table with the certificates sorted by CertificateID
so the order should be U, PG, 12, 12A, 15, 18, Unknown
but the table not to show CertificateID
I can do it with the CertificateID visible - easy, but as soon as I remove it the order resets
OR
A matrix with column headers of Certificate in the above order
The raw source file Excel is as below (Just using the Certifcates Sheet)
https://www.dropbox.com/scl/fi/mepyd9ud4k0zdgkqnoeeo/Films.xlsx?rlkey=46pwud1pm1teic4uql7zsogng&st=2...
Many thanks in advance
Solved! Go to Solution.
For your reference.
Please try ’Sort by column’.
| User | Count |
|---|---|
| 23 | |
| 20 | |
| 18 | |
| 16 | |
| 10 |
| User | Count |
|---|---|
| 53 | |
| 52 | |
| 40 | |
| 37 | |
| 32 |