Format value to Percentage based on value from another column

[kimloh_p]

hi community folks,

I would like know how we can create a measure to format [KRI] value to % if the column[Metric_Type] = Percentage, else don't change the format.

Metric_Type	KRI	(expected outcome)
Number	9	9
Percentage	1	100%
Percentage	0.95	95%
Number	1	1

Any advise and help is greatly appreciated.

[amitchandak]

@kimloh_p , I doubt that.

You can use format , but that will make output as text

refer: https://radacad.com/dynamically-change-the-format-of-values-in-power-bi

https://www.youtube.com/watch?v=21xZphzYgoY