Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Conditional Formatting % Values ONLY

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 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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