Forum Discussion
Power BI bar chart help
I have the following table:
YEAR | Id_student | Test_grade | level |
2019 | A | 150 | Level 0 |
2019 | B | 200 | Level 1 |
2019 | C | 200 | Level 1 |
2019 | D | 225 | Level 3 |
2019 | E | 250 | Level 4 |
2019 | F | 280 | Level 5 |
2019 | G | 300 | Level 6 |
2019 | H | 320 | Level 7 |
2019 | I | 350 | Level 8 |
2019 | J | 370 | Level 9 |
2019 | K | 225 | Level 3 |
2019 | L | 290 | Level 5 |
2019 | M | 350 | Level 8 |
2020 | N | ... | ... |
I need to find the percentage of each level in relation to the total for the year. I'm trying to assemble the following visual from the table but without success.
The result I'm getting are very close and very thin columns. Can anybody help me?
Hi juniorcef
You can acheive your result with built-in option itself.
on the Y axis, click the drop down of the field click show value as and choose "Percent of grand total".
If you use measure then this option will not come. if you have measure then you need to get the result using DAX measure.
Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin
3 Replies
Hi juniorcef
You can acheive your result with built-in option itself.
on the Y axis, click the drop down of the field click show value as and choose "Percent of grand total".
If you use measure then this option will not come. if you have measure then you need to get the result using DAX measure.
Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My LinkedinHi juniorcef
You are getting thin line because you are using one of the field in the legend. If that is the case then each level will look for all the ID so it will be thin. Check whether you still need to add legend. You can give colors for each levels.
Thanks
Hari
THANK YOU SO MUCH. IT WORKED OUT!
