Forum Discussion

Dooriya101's avatar
Dooriya101
Frequent Visitor
3 years ago

Multiple conditions in SWITCH ()

Hi Team,   I have a Case Table and Priority Table, and have a column chart to show average of Time, and have another DAX code to have colour settings like if actual time is within 50% of target tim...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Dooriya101 , Hope both tables are joined. You have to create a measure like, You can add additional conditions as per need

 

var _a = sum(Table2[Actual time])
var _p = Max(Table[Pirority])
return
Switch( True()
_= "A" && _a<= 2*1.5, "Green",
_= "A" && _a<= 2*1.8, "Yellow",
_= "A" && _a> 2*1.8, "Red"
// add other
)

 

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3

Dooriya101's avatar
Dooriya101
Frequent Visitor
3 years ago

Hi Amitchandak, thenks for you reply and link provided. I've created DAX code as your advised, but when I try to apply in column chart, it doesn't allow me to choose it.

 

 

 

Below are my codes in product environment:

 

var _a = sum('SLA Closed'[SLA Response Duration (in Hours)])
var _p = Max('Priority - SLA Response Target Hours'[Priority])
return
Switch(
    True(),
    _a= "Critical" && _a<= 2*1.05, "Green",
    _a= "Critical" && _a<= 2*1.08, "Yellow",
    _a= "Critical" && _a> 2*1.08, "Red",
    _a= "High" && _a<= 4*1.05, "Green",
    _a= "High" && _a<= 4*1.08, "Yellow",
    _a= "High" && _a> 4*1.08, "Red",
    _a= "Medium" && _a<= 8*1.05, "Green",
    _a= "Medium" && _a<= 8*1.08, "Yellow",
    _a= "Medium" && _a> 8*1.08, "Red",
    _a= "Low" && _a<= 16*1.05, "Green",
    _a= "Low" && _a<= 16*1.08, "Yellow",
    _a= "Low" && _a> 16*1.08, "Red")
 
Thanks!