How to Format Percentage and Whole Numbers in the same table

[HagenHawke]

Hi Community,

Could you please help me to  format percentatge and whole numbers in the same matrix? I want  the matrix to show  % as percentage and numbers as whole number.

Below is a an example table.

Company	Metric	1H18	2H19
A	Cash earnings	1,200	2,208
A	Net Interest Income	5,000	6,225
A	Total Operating Expenses	-      2,554	-        2,518
A	Net Interest Margin %	-2.0%	-3.0%
C	Cash earnings	121	269
C	Net Interest Income	321	520
C	Total Operating Expenses	-         621	-            369
C	Net Interest Margin %	-2.9%	3.5%
E	Cash earnings	1,251	2,968
E	Net Interest Income	7,215	6,213
E	Total Operating Expenses	-      4,215	-        4,578
E	Net Interest Margin %	-5.0%	-6.0%

Thanks in advance.

Regards,

M

[amitchandak · Accepted solution]

@HagenHawke , You can use format function

Switch(Max(Table[Metric]) ,

"Net Interest Margin %", format([1H18], "percent") ,

"Total Operating Expenses", format([1H18], "#,###") ,

//add other

format([1H18], "#,###")

)

refer

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

[HagenHawke]

Thank you so much. It works.

Kind regards,

M