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.

[Anonymous]

Hi @sujana_m ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[Anonymous]

Hi sujana_m ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If the issue still persist,find the below answer:
In Power BI, adding "pp" makes the measure text, so it won’t be treated as a number. The best approach is to keep your original numeric measure for calculations and create a separate display measure like FORMAT([CCI MS] - [CCI MS PY], "0.00") & " pp" to show "pp" in visuals where needed.
Thank you for being a part of the Microsoft Fabric Community Forum!

[Anonymous]

Hi @sujana_m ,
May I ask if you have gotten this issue resolved?
If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[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.