The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 @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.
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.