How to Format Percentage and Whole Numbers in the same table

Question

Hi Community,&nbsp;Could you please help me to&nbsp; format percentatge and whole numbers in the same matrix? I want&nbsp; the matrix to show&nbsp; % as percentage and numbers as whole number.&nbsp;Below is a an example table.CompanyMetric1H182H19ACash earnings&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,208ANet Interest Income&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,225ATotal Operating Expenses-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,554-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,518ANet Interest Margin %-2.0%-3.0%CCash earnings&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 121&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 269CNet Interest Income&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 321&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 520CTotal Operating Expenses-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 621-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 369CNet Interest Margin %-2.9%3.5%ECash earnings&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,251&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,968ENet Interest Income&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,215&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,213ETotal Operating Expenses-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,215-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,578ENet Interest Margin %-5.0%-6.0%&nbsp;Thanks in advance.&nbsp;Regards,M

amitchandak · Accepted Answer

Anonymous , You can use format function 
&nbsp;
Switch(Max(Table[Metric]) ,
"Net Interest Margin %", format([1H18], "percent") ,
"Total Operating Expenses", format([1H18], "#,###") ,
//add other
format([1H18], "#,###")
)
&nbsp;
refer
https://radacad.com/dynamically-change-the-format-of-values-in-power-bi

Forum Discussion

How to Format Percentage and Whole Numbers in the same table

2 Replies

Related content

Percentage Formatting

number format help

Number Format Issue

Format number and percentage

Organizational Apps - number format

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%