Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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).
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
Hi @Anonymous
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.
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
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.
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.
User | Count |
---|---|
98 | |
76 | |
75 | |
49 | |
27 |