Dynamic Formatting Percentage shows value as 100 times larger e.g. 0.021 -> 212%

[Zoe_Guest]

I am trying to show values as a percentage using dynamic formating but the values are not showing correctly. They are 100 times larger in some cases.

I have a column "kpi_value_mean".

Measure = SUM(cfd_kpi_gold_trends[kpi_value_mean])

Dynamic Format = 

VAR kpi_result = SELECTEDMEASURE()

RETURN

SWITCH(

    MAX(cfd_kpi_gold_trends[kpi_type]),

    "1", FORMAT(kpi_result, "Percent"),

    "2", FORMAT(kpi_result, "Standard"),

    "General"

)

The result of the measure and the raw column in a table:

Some of the values are not showing correctly. Why are they not showing as the value as a percent? How can I get them to show correctly? The underlying data seems correct as on a line chart the values are correct but the tooltip shows the wrong value.

The measure is created in the model. It is a direct lake on OneLake model.

[Zoe_Guest]

Thank you that has worked! 😄

[grazitti_sapna · Accepted solution]

Hi @Zoe_Guest,

Issue is with FORMAT(kpi_result, "Percent") line, as it's converting KPI result to text and scaling it by 100.

Use below measure instead

VAR kpi_type = MAX(cfd_kpi_gold_trends[kpi_type])

RETURN
SWITCH(
kpi_type,
"1", "0.00%",
"2", "#,##0",
"General"
)

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!