Format number and percentage

[Sander1401]

Hi all,

I have two (I hope) simple questions about formatting.

My first question is about percentages, I would like to show my percentages in a KPI-card as followed:

0 > 0%

below 100% > 56,6% so with one digit

100% > 100%

when I use this one under dynamic, it works, except for the 100%, there it says 100,0%.
Is there a way to fix that? Or do I need to use an IF statement together with a FORMAT statement in my measure?

My second question is about numbers, I don't want to see (Blank), but 0.
I know I can make a new measure just for KPI's, with +0 added to the formula, but is there also a way to do this via the Measure tools - Format?

Thanks in advance!

[nilendraFabric · Accepted solution]

yes use if :

Formatted Percentage =
IF(
[YourPercentageMeasure] = 1,
"100%",
FORMAT([YourPercentageMeasure], "0.#%")
)

I think measure is easiest way

Formatted Number = COALESCE([YourMeasure], 0)

please accept the answer if this helps 

[Anonymous · Accepted solution]

Hi @Sander1401 ,
Thanks for nilendraFabric reply.

You can try to do this by using the dynamic formatting of measure and modifying some of the mesaure code.
For example, write measure using the following logic

Percentage = 
IF(
    MAX('Table'[Value])/MAX('Table'[Target]) = BLANK(),
    0,
    MAX('Table'[Value])/MAX('Table'[Target])
)

 and modify its dynamic format

IF(
    [Percentage] = 0 ||[Percentage] = 1 ,
    "0%",
    "0.0%"
)

Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[nilendraFabric · Accepted solution]

yes use if :

Formatted Percentage =
IF(
[YourPercentageMeasure] = 1,
"100%",
FORMAT([YourPercentageMeasure], "0.#%")
)

I think measure is easiest way

Formatted Number = COALESCE([YourMeasure], 0)

please accept the answer if this helps