Forum Discussion
Solved
Percentages
Hello everyone at the Power BI forum,
I'm a complete newbie to this but I'm finding it very interesting so far!
I have a slight issue with something that I hope can be resolved easily. I have a clustered column chart on the x-axis with 5 categories, each category has 4 bars.
I'd really like to see the values as percentages but at the moment they're in decimal form and I have no idea how to change this?
The Y-Axis contains the data for the 4 bars and was calculated using a simple DAX formula [for example, one of the bars which is the 'pass percentage' is calculated by this:
PassPercentage =
DIVIDE(
CALCULATE(COUNTROWS('studentInfo'), 'studentInfo'[final_result] = "Pass"),
COUNTROWS('studentInfo'),
0
)]
Any help with this would be massively appreciated, thank you in advance!
DB2023
DB2023
