CODEWITHSUNDEEP
tableau-api
Tihor
Tihor

Reputation: 59

Conditional formatting on numeric and date measure value

Is there a way to conditional format a measure value as date in some case and numeric in some cases? I have a measure value Max, however some measure are dates and some are numeric. If I convert everything to numeric I lose dates and viceversa. can we just select a single measure and define max of it as a date and for others as numeric?

Upvotes: 1

Views: 1262

Answers (1)

Talvalin
Talvalin

Reputation: 7889

This will depend on how your dates are formatted, but a date in dd/mm/yyyy format could be identified by the following calculated field.

IIF((FIND(ATTR([Max]), "/") > 0), 'Date', 'Number')

Identifying numeric or date values using a calculated field

Upvotes: 2

Related Questions