Number formatting options on Table visualizations

[ssvr]

I want to change the numer format in Table visualisation from Power BI

From 0.95 to Percentage ??

Note:  I worked on Cubes so I dont have the Query editor option

[Anonymous · Accepted solution]

HI @ssvr,

If you mean you are create report in live connection mode, current format tab not available on this mode.
I'd like to recommend you to write a measure to format your numeric value.

Reference:

FORMAT Function (DAX)

• Pre-Defined Numeric Formats for the FORMAT Function

• Custom Numeric Formats for the FORMAT Function

• Pre-defined Date and Time formats for the FORMAT Function

• Custom Date and Time formats for the FORMAT Function

Notice: format function will transform your value as text format which you can't direct use in calculation.

Regards,

Xiaoxin Sheng

[ssvr]

Thanks Xiaoxin Sheng