I am trying to conditional format my column chart based on the status of the columns. I have data that is coming in for the status as colours (red, green, yellow). I am trying to use the switch function to switch the columns to thier respective status colour.
This is a sample of the data set.
| Staff | PT | Car | Staff Status | PT Status | Car Status |
| 4 | 6 | 3 | Yellow | Green | Red |
What I have done is pull that data in and filter by max date so it only shows me the data for the latest. Then I use the switch function to display the number for each column. (as a column chart) which works even though of the sum aggregation because it is filter to only one row of data.
Measure Value =
SWITCH(
SELECTEDVALUE('Measure'[Measure]),
"Staff",SUM(response[Total Staff]),
"PT",SUM(response[Total PT]),
"Car",SUM(response[Total Car]),
)
This is the dax measure that i am using which does not work.
Measure Colour =
SWITCH(
SELECTEDVALUE('Measure'[Measure]),
"Staff",MIN(response[Staff Status]),
"PT",MIN(response[PT Status]),
"Car",MIN(response[Car Status]),
)
I have tried all the aggregate functions (sum, average, min, max)
