Hi All I have this worksheet below. I have set colours for each mesure as indicated how ever I would like to change each colour conditional to the SALES Area. At the moment it is all set to one varible but I would to do this by each area therefore I can change the conditions
I have tired to do a case statement
for example say to say
Area A then if crf% <=0.5 then "Red"
Area B then crd%<=0.6 then "Red
Area c the crf%<=0.7% the "red"
Each of the measure will have a different conditon for each different area. Does anyone have any ideas
The functionality to have different conditions on colours is limited. You can only have measure values on colour of the marks card. To achieve the desired result, you can split the chart to have a single measure in one worksheet, with a single conditional calculation, and combine these by puting them together in a single dashboard.