Conditional Formatting

[Anonymous]

Hi,

Consider the following Dataset,

Usually, we apply conditional formatting for Integer numbers and Percengates respectively. I have a requirement that value column has both numbers and percentages together in the dataset. I need to apply conditional formatting for these values based on the rule. Rule is like >50%, 75% and <250, <500, etc..

Solutions will be greatly appreciated.

Regards,

Pradeep

[tex628 · Accepted solution]

Create a measure, [Conversion] where you convert all the values from [Value] to numeric. Then apply conditional formatting on [Value] that is based on [Conversion]:

As long as your numeric and percentage values never intersect it should simple work witha  normal rule based conditional formatting.