Area Chart Y-Axis Issue - Displaying Percentage Instead of Count (AcceptedPercentageFormatted)

[manoj_0911]

Hi everyone,

I'm trying to create an Area Chart in Power BI with the following setup:

* X-Axis: MonthYear = FORMAT('AGENT_SUBHOUR_V'[IXN_SUBHOUR_DATE], "MMM-YYYY")
* Y-Axis: AcceptedPercentageFormatted = FORMAT(DIVIDE(SUM('AGENT_SUBHOUR_V'[ACCEPTED]), SUM('AGENT_SUBHOUR_V'[OFFERED])), "0.00%")

However, when I place the "AcceptedPercentageFormatted" measure on the Y-axis, the chart displays the count of the percentage values instead of the actual percentage itself.

Can anyone advise on how to ensure the Y-axis displays the calculated percentage values (e.g., 50.00%) instead of their count?

Thank you in advance for any assistance!

[HotChilli · Accepted solution]

FORMAT returns a string and powerbi won't apply SUM to that.  So remove the FORMAT , see if that gets you a bit closer.

If you need to show the number in a different way use powerbi built-in display features to change (via interface)