Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Syndicate_Admin
Administrator
Administrator

Conditional formatting blocked for Integers

Hello people,

I'm looking to add conditionally formatted icons to an array, these should be formatted based on number rather than percentages. (they must vary according to a defined Target that is also an integer).

However, in attempting this, I see that the format levels are locked to a combination of Number and Percentage (see below).

laracenac_0-1664564009239.png

I tried to perform this exercise by modifying the formatting from text to number and vice versa, passing it to measure, calculating it from a column and I have not had major news, it is still blocked.

How can I change all these drop-down menus to set the format levels to 'Number'?

Thanks a lot

5 REPLIES 5
v-jingzhang
Community Support
Community Support

Hi @laracenac 

 

Does your measure "Total BdE" return numeric data? Based on my test, I'm able to switch Percentage to Number when I base it on a measure. 

vjingzhang_1-1664867747275.png

If it still doesn't work, please update your Power BI Desktop to the latest version and test if this happens on the latest version. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Yes, im trying to do it with a measure and with the column.

Neither of both ways give me a result.

Also, i have the latest version of power bi

Syndicate_Admin
Administrator
Administrator

I still cannot solve my query and for data privacy I can not provide the pbi.

Best regards

If you cannot provide sanitized sample data then I cannot help.

lbendlin
Super User
Super User

They should not be locked. Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.


Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors