Grade distribution Graph

[Tim_Smith]

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.

[Tim_Smith]

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.

[v-deddai1-msft]

Hi @Tim_Smith ,

I'm not getting very well from your requirements, how do you want to sort the column?

Best Regards,

Dedmon Dai

[amitchandak]

@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