DAX gradient format

[Evelin_]

Hello,

I need help regarding my DAX, as I can not use gradient conditional format in the table, due to its text format. How Can I edit this dax to get number format? I tries some ways but still in text format.

Thank you in advance!

[johnt75 · Accepted solution]

Leave your measure returning a numeric value so that you can use it in conditional formatting, charts etc, but change the format string to custom and enter your desired format string in that field. The result will be numeric but will be displayed as you want it to be.