Adding visual text to the end of number and keep percentage formatting

[sujana_m]

Hi everyone,

I am trying to add "pp" (percentage points) to the end of the number in my variance measure. However, I only want to change "pp" for some of my visuals, not the measure format in the back end. At the same time, I don’t want Power BI to convert it to text.

I have a measure that returns a Market share variance value, e.g., 1.56%. I modified it by appending text to display 1.56 pp, so I would like to replace the % symbol with "pp" while keeping the measure numeric.

Measure Format e.g.

i want see MS Var -1.16pp instead -1.16%

Does anyone have a solution for this?
Thanks.

[rajendraongole1]

Hi @sujana_m  - Since Power BI does not allow appending text to numbers while keeping them numeric, you can create a separate measure for visuals where you need "pp"

MS_Var_Display =

VAR Value1 = DIVIDE(AVERAGE('Condition'[Actual $ Value]),SUM('Condition'[Actual $ Value])) -- Your original market share variance measure

RETURN

    FORMAT(Value1, "0.00") & " pp"

Hope this helps.

[bhanu_gautam]

@sujana_m 

Create a new measure that formats the number as a string and appends "pp" to it. This will convert the measure to text for display purposes.

Formatted MS Var =
VAR MSVar = [CCI MS] - [CCI MS PY]
RETURN
FORMAT(MSVar, "0.00%") & " pp"

[sujana_m]

Hi Gautam, thanks for the solution, but I want to see only PP after the number, not the % symbol. e.g -1.99pp

[bhanu_gautam]

@sujana_m 

use this then Formatted MS Var =
VAR MSVar = [CCI MS] - [CCI MS PY]
RETURN
FORMAT(MSVar, "0.00") & " pp"

[sujana_m]

I also tried this approach, but it is not working as I expected.

with out %  numbers.