Conditional Formatting % Values ONLY

[Anonymous]

Hi Experts

I am trying to format in White Font Colour the Metrics that start with a % sign in my Table. I have in the Logistics Table a Column OrdNo where i have assigned a 1 for % values and 0 for all other values. When I try and apply Conditional Formating to The Metrics Values in the table - by selecting RULE > and The OrdNo from the Logistics Table and the Value is 1 (CF) it also formats in white font other Attributes in the table (See image) of CF Steps

Sample File:

https://www.dropbox.com/s/iwgxv3k7079roos/Logistics.pbix?dl=0 

[Anonymous · Accepted solution]

Hi,

if I understand it correctly, you can do it like this,

First, you create a column;

Find % = IF(LEFT(Logistics_[New_Reporting_Headers],1) = "%" , 0 ,1)

then you can apply condition; I use yellow and red color