根据行、列共同判断颜色
效果
新建两个度量值分别设置背景色和字体，
度量值要设置成文本格式！！
然后字段条件格式按照字段就可以了
color bg = switch(
true(),
SELECTEDVALUE('L2'[L2])="<1/3","#E2EFDA",
SELECTEDVALUE('L2'[L2])="1/3-1/2" && SELECTEDVALUE('Location'[Name]) = "Retail","#E2EFDA",
SELECTEDVALUE('L2'[L2])="1/3-1/2" && SELECTEDVALUE('Location'[Name]) = "RDC","#FFCCCC",
SELECTEDVALUE('L2'[L2])="1/3-1/2" && SELECTEDVALUE('Location'[Name]) = "DT DSP","#FFF2CC",
SELECTEDVALUE('L2'[L2])="1/3-1/2" && SELECTEDVALUE('Location'[Name]) = "DT WS","#FFF2CC",
SELECTEDVALUE('L2'[L2])="1/3-1/2" && SELECTEDVALUE('Location'[Name]) = "EC DSP & WS","#FFF2CC",
SELECTEDVALUE('L2'[L2])="1/2-2/3"&& SELECTEDVALUE('Location'[Name]) = "Retail","#FFF2CC",
SELECTEDVALUE('L2'[L2])="1/2-2/3"&& SELECTEDVALUE('Location'[Name]) = "RDC","#FF6161",
SELECTEDVALUE('L2'[L2])="1/2-2/3"&& SELECTEDVALUE('Location'[Name]) = "DT DSP","#FFCCCC",
SELECTEDVALUE('L2'[L2])="1/2-2/3"&& SELECTEDVALUE('Location'[Name]) = "DT WS","#FFCCCC",
SELECTEDVALUE('L2'[L2])="1/2-2/3"&& SELECTEDVALUE('Location'[Name]) = "EC DSP & WS","#FFCCCC",
SELECTEDVALUE('L2'[L2])=">2/3","#FF6161"
,"white")
color text = switch(
true(),
SELECTEDVALUE('L2'[L2])="<1/3","#33CC33",
SELECTEDVALUE('L2'[L2])="1/3-1/2" && SELECTEDVALUE('Location'[Name]) = "Retail","#33CC33",
SELECTEDVALUE('L2'[L2])="1/3-1/2" && SELECTEDVALUE('Location'[Name]) = "RDC","#FF7A7A",
SELECTEDVALUE('L2'[L2])="1/3-1/2" && SELECTEDVALUE('Location'[Name]) = "DT DSP","#FFCC00",
SELECTEDVALUE('L2'[L2])="1/3-1/2" && SELECTEDVALUE('Location'[Name]) = "DT WS","#FFCC00",
SELECTEDVALUE('L2'[L2])="1/3-1/2" && SELECTEDVALUE('Location'[Name]) = "EC DSP & WS","#FFCC00",
SELECTEDVALUE('L2'[L2])="1/3-1/2" ,"#FFCC00",
SELECTEDVALUE('L2'[L2])="1/2-2/3"&& SELECTEDVALUE('Location'[Name]) = "Retail","#FFCC00",
SELECTEDVALUE('L2'[L2])="1/2-2/3"&& SELECTEDVALUE('Location'[Name]) = "RDC","#C00000",
SELECTEDVALUE('L2'[L2])="1/2-2/3"&& SELECTEDVALUE('Location'[Name]) = "DT DSP","#FF7A7A",
SELECTEDVALUE('L2'[L2])="1/2-2/3"&& SELECTEDVALUE('Location'[Name]) = "DT WS","#FF7A7A",
SELECTEDVALUE('L2'[L2])="1/2-2/3"&& SELECTEDVALUE('Location'[Name]) = "EC DSP & WS","#FF7A7A",
SELECTEDVALUE('L2'[L2])="1/2-2/3","#C00000",
SELECTEDVALUE('L2'[L2])=">2/3","#C00000"
,"black")
