Forum Discussion
Grade distribution Graph
Hi All,
I am very new to Power Bi. I'm trying to create a grade distribution graph which i have managed to sort. however, I would like to compare it to a target distribution. also on the graph that i have it doesnt show all the numbers (1 to 9) in the X axis. this is hopefully a simple one to sort. i thought i would be able to use the line and cluster column chart but it doesnt seem to work as i just get the same value for both. i've included a picture of an excel graph which would be perfect if i could get it to look the same or similar.
Many Thanks for your support.
3 Replies
Tim_Smith , to Get all the number to choose axis type categorical in place on continuous
I doubt you can change much with visual display.
You can check histogram, if needed https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380776?tab=Overview
Thank you, i did try that to get all the numbers but it then ranked the grades in the wrong order on the graph. i guess i'm just going to have to graphs, one that shows the grade distribution for the assessment and one that shows the targets distribution. Thanks get replying.
Hi Tim_Smith ,
I'm not getting very well from your requirements, how do you want to sort the column?
Best Regards,
Dedmon Dai
