formula to format measures

[Anonymous]

Can I condititionally format a measure?

For example if a metric is CPC or CTR then to format as a percentage, otherwise as $

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, the easiest way is using the format feature in 'Modeling' ribbon. As a workaround, you may try the following steps.

Here is my example.

Table:

FormatTable:

Then you may create a measure as below.

FormatSales = 
var _currentformat = SELECTEDVALUE(FormatTable[Format])

return 
IF(
    OR(_currentformat = "CPC",_currentformat = "CTR"),
    MAX('Table'[Sales])/100&"%",
    "$"&MAX('Table'[Sales])
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Options is under Data modeling tab.

Refer : https://radacad.com/custom-format-fields-and-measures-in-power-bi

https://community.powerbi.com/t5/Desktop/Formatting-measure-values-as-currency/td-p/17254