How to format new measure (not column) in power BI as percentage?

powerbi dax
Dave D. picture Dave D. · Jul 13, 2016 · Viewed 59.4k times · Source

When I create a new measure with formula, i.e. sum(col1)/max(col2), it automatically converts the result into #.#% format. Strangely, it doesn't happen all the time; sometimes it just gives result #.## format.

Any idea of how to format a new measure (not column) to be treated as percentage?

Answer

Stephan picture Stephan · Jul 13, 2016

In Power BI there is a option in the taskbar when you enter your measure.

In Power Pivot for Excel you can select the format directly in the measure editor (Or editor for calculated fields. The name depends on your version of Excel)

If you want to take over manually you can also use the Format() formula:

= FORMAT(Sum(Table[Field]),"0.00%")

Related questions

how to convert a Integer to Text value in Power BI

I am creating a calculated column in existing power BI report. the calculated column concatenates integer & text columns. I tried below query which give syntax error to me, = Number.ToText(table1.[RegionID]) & " " & table1.[RegionName] I tried some …

Read More
How to get month name from month number in Power BI?

I have Year number and Month Number in my data. How using DAX can I get the month name out of month number? In SSRS its very easy. But how to achieve that using DAX?

Read More
Multiple IF Statements in DAX

I currently have Column Data formulated below in Power BI which I need for it to display in one column but replacing the "1" with a Text value being: Orginal column formula: Age (18-27) = IF(AND([Age]>17, [Age]<28),"1",BLANK()) …

Read More