Forum Discussion
How to put different values from the same column into different columns in a visualisation
Hopefully I am going to explain this clearly....
I have three tables; one that contains student details as follows
One that contains the report cycles
and a final one that contains the grades for a student for that report cycle (the kicker is that for some report cycles, the subject is further split into sub subjects - e.g. English has the sub subjects of English Lit and English Lang).
What I need to accomplish is, for a selected student, we see a list of all sub subjects listed from the A Level Likely Outcomes, with the likely outcome next to them, and the grade from the Fifth Form Grades cycle (with a blank if there is no previous grade for that sub subject).
So if we chose Jimmy, we would see something like the following
How can I accomplish this? (is it even possible?)
3 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi, RFJammer
Does danextian 's method solve your problem? If it has been resolved, please accept the reply that helped you as a solution. If it has not been resolved, please provide more information.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
