Forum Discussion
Field Conditional Formatting Table with multiple measures
Instead of using a table for this data, it may be easier to use a matrix instead with a single measure rather than individual measures for each day and hand some of the filtering off to the visual level rather than the measure level. You would put the day of week in the column field and the location in the row field, then your measure in the values field. Then, you can implement conditional formatting on a single measure based on the SELECTEDVALUE of the row and column through the existing relationship.
Instead of using a table for this data, it may be easier to use a matrix instead with a single measure rather than individual measures for each day and hand some of the filtering off to the visual level rather than the measure level. You would put the day of week in the column field and the location in the row field, then your measure in the values field. Then, you can implement conditional formatting on a single measure based on the SELECTEDVALUE of the row and column through the existing relationship.