Have '%' symbol show on a calculated column and do conditional formatting

[Jmtl1966]

I have data of 50+ locations and a weekly analysis of a Phishing campaign (set up by othe organization). I can click any individual location and see the right data including an overal Phish Prone percentage but if I want an overall percentage it sums it all up which is not right. As such I made a calculated column of: Phish Prone % = DIVIDE ([Total Fail],[Delivered])*100 which works fine under all conditions.

The issue is I am not able to get it to show the result with the % symbol (ex: 1.16% --> only shows as 1.16).

I was able to concatenate the result with a '%' symbol as part of the measure but then I cannot do any conditional formatting based on the values because the concatenation turns it into a string not a value.

Any help appreciated.

[Jmtl1966]

Hi, I need  some time to get on this. Unfortunately that may not be for some weeks as I have other priorities and vacation coming up.

If you need to lcose this fo rnow then feel free.

[v-bmanikante]

Hi @Jmtl1966 ,

Thanks for the update, totally understand priorities and time constraints.

We'll go ahead and close this for now. If you need further assistance,  please feel free to reopen a new thread.

Regards,

B Manikanteswara Reddy

[Jmtl1966]

ogies everyone, I just have nbot had time to look at possible answers. It may only be next week due to priorities at work with my manager in town until end of next week.

Please bear with me.

[v-bmanikante]

Hi @Jmtl1966 ,

Thanks for the update! No worries, we completely understand that priorities can shift.

Whenever you get a chance to review the solutions provided, please let us know how it goes. If one of the responses resolves your issue, we’d really appreciate it if you could mark it as the accepted solution. This helps other community members who may be facing the same issue.

Looking forward to hearing back from you!

Please don't forget to give a "Kudos " – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[burakkaragoz]

Hi @Jmtl1966 ,

Yeah, that’s a common issue — once you concatenate the % symbol, the value becomes text and you lose the ability to do conditional formatting.

Here’s what you can do instead:

1. Keep the calculated column as a number:

Phish Prone % = DIVIDE([Total Fail], [Delivered])

1. Then in the Model view, select the column and set the format to Percentage with 2 decimal places. This will show values like 1.16% without needing to concatenate anything.

2. Now you can apply conditional formatting in visuals based on this column, since it’s still numeric.

Don’t multiply by 100 manually — Power BI does that automatically when you set the format to Percentage.

Let me know if you're using this in a table visual or card, I can help fine-tune the display.

---

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI

[Jmtl1966]

I do not see the calculated column in the model view.

Model view has Phish Prone % but that is from my data source which is no good on the cumulative level as per previous info.

Why am I not seeing the New Phish Prone % in the model view as you implied?

Cheers, appreciate the guidance. Getting to know PowerBI but things like this is driving me nuts!

[Jmtl1966]

So in my Model I created a New Column with that equation, set it like you said to Percentage and on the individual level shows fine. Unfortnuately though when it is not on an individual level but the whole corporation, it gives a sum of all Phish Prones. That's what is th ebig issue.

New Phish Prone % is what works fine, the Sum of Test PP is obviously not right as it should match as 1.66%

[v-bmanikante · Accepted solution]

Hello @Jmtl1966 ,

Thank you for reaching out to Microsoft Fabric Community Forum.

@burakkaragoz Thank you for your quick response.

@Jmtl1966To ensure accurate aggregation at all levels, especially for overall  summaries, it is recommended to use a measure instead of a calculated column to compute the Phish Prone %.

You can define the measure as follows:

Phish Prone % = DIVIDE(SUM([Total Fail]), SUM([Delivered]))

Using a measure ensures that the percentage is dynamically calculated based on the current filter context,providing correct values at both individual and total levels(Sum of Test PP). In contrast, a calculated column computes row-level values and can lead to misleading totals when aggregated (e.g., summing up percentages across rows).

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @Jmtl1966  ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Please don't forget to give a "Kudos " – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @Jmtl1966 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Please don't forget to give a "Kudos " – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy