limit percentage to 3 digits

[H_SL]

Hello community!

How can i limit the number of digits of a percentage into 3 digits only? i want my limits to be 999% to -999%, otherwise, "N/A"

i.e how can i have "N/A" instead of 4010%

i.e 

[Anonymous · Accepted solution]

Hi H_SL,

Yes, you can control it by using DAX Expression. 

For Example, if your percentage is a measure that it returns values.

You can create one more measure and write DAX Expression like,

=IF(AND([Percentage]>-999, [Percentage]< 999), [Percentage], 'N/A')

Hope this helps you a lot.

Regards,

Pradeep