Forum Discussion
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).
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
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-p/963216
Please show the expected outcome based on the sample data you provided.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.
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
