Forum Discussion
Field Conditional Formatting Table with multiple measures
- 1 year ago
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.
Hi 50ryk
You could use a calculation group. That will allow you to use one measure for all outcomes. You could use this instead of a separate measure for each day as well.
The following videos will give you what you need and more
Unlock the Full Potential of CALCULATION GROUPS in Power BI Desktop | Oct 2023 Power BI Update - YouTube
How to Conditional Format CALCULATION GROUP Columns in Power BI
Please give a thumbs up and mark as solved if this helps, thanks!