Measures not Rounding Correctly

[Anonymous]

Hello,

I am having an issue producing the correct output. 

In the picture above, all values are individual KPI visuals. I have a calculated metric for 3.4 Audience Spend (Avg.) which is 3.2 / 3.1, which produces $6.09 in the 2nd column and $6.06 in the 3rd column. Both of these values are set to Currency in the data modelling tab with 2 decimals configured. 

In the 5th column, the $0.03 highlighted is the difference between $6.09 and $6.06.

Now, the number circled in red is supposed to be percentage change between these two calculated measures (i.e. ($6.09 - $6.06) / $6.06), which is, rounded to 2 decimals, 0.5%, however as you can see the measure is showing 0.53%. 

I believe Power BI is not rounding for 2 decimals in the measures that are being used in the calculation for the lift measure. How do I fix this to show 0.5%?

[cmilligan262 · Accepted solution]

@Anonymous I don't believe you can change the rounding of the actual number just of the number in the visual. If you just want to show 0.5% you'll have to change the rounding of the number of decimals in the modeling tab to 1.

You may be able to write code in power query to round the numbers coming in, but that is outside my knowledge.

[Anonymous]

I believe you are right @cmilligan262 , you cannot change the rounding of the actual number. Instead used ROUND() function within my measure.