Dataempower

The complete list of Tabular Editor formatting: <table><colgroup><col><col><col></colgroup><tbody><tr><td>Type</td><td>Code</td><td>Example</td></tr><tr><td>0 Decimals with thousands separator</td><td>“#,##0.”</td><td>524,456</td></tr><tr><td>2 Decimals with thousands separator</td><td>“#,##0.00”</td><td>524,456.00</td></tr><tr><td>$ Sign with K for thousands</td><td>“$#,##0,.K”</td><td>$5,245K</td></tr><tr><td>millions with separator</td><td>“#,##0,,.M”</td><td>5M</td></tr><tr><td>Percentage with 2 decimals</td><td>“0.00%”</td><td>5.25%</td></tr><tr><td>Percentage with 0 decimals</td><td>“0%”</td><td>5%</td></tr><tr><td>Whole Number</td><td>0</td><td>122</td></tr><tr><td>Percentage Points</td><td>0.0 &#34;pct&#34;</td><td>12.5 pct</td></tr><tr><td>Scientific format with 2 decimal places</td><td>0.00E+00</td><td>4.05E+4</td></tr><tr><td>Text Format</td><td>@</td><td>4.556565656565775</td></tr><tr><td>Custom text plus number format</td><td>&#34;your lucky number is:&#34; #,0.00</td><td>your lucky number is: 34.45</td></tr></tbody></table>

Tabular Editor Formatting

I am just being curious if Fabric will replace most of BI infrastructure (Power BI, SQL, Synapse, Azure Data Factory, ML, etc...) .... still investigating :)

#editor

#formatting

#tabular

#tabulareditor

Dataempower

Dataempower

Type	Code	Example
0 Decimals with thousands separator	“#,##0.”	524,456
2 Decimals with thousands separator	“#,##0.00”	524,456.00
$ Sign with K for thousands	“$#,##0,.K”	$5,245K
millions with separator	“#,##0,,.M”	5M
Percentage with 2 decimals	“0.00%”	5.25%
Percentage with 0 decimals	“0%”	5%
Whole Number	0	122
Percentage Points	0.0 "pct"	12.5 pct
Scientific format with 2 decimal places	0.00E+00	4.05E+4
Text Format	@	4.556565656565775
Custom text plus number format	"your lucky number is:" #,0.00	your lucky number is: 34.45