SRSS if / else SWITCH

Question

У меня есть гистограмма, которую я хотел бы иметь разные цвета для каждой категории.

Пока что я делаю это с ПЕРЕКЛЮЧАТЕЛЕМ, но я не мог понять, как / если возможно поставить еще один конец там.

Мой код выглядит так:

    =SWITCH(
Fields!Style_Name.Value = "Vagabond Pale Ale", "CornflowerBlue",
Fields!Style_Name.Value = "This Is Lager", "Orange", 
Fields!Style_Name.Value = "Punk IPA", "#00AFDB", 
Fields!Style_Name.Value = "Nanny State", "White", 
Fields!Style_Name.Value = "Jet Black Heart", "DimGray", 
Fields!Style_Name.Value = "Dead Pony Club", "SeaGreen", 
Fields!Style_Name.Value = "5am Red Ale", "Maroon", 
Fields!Style_Name.Value = "KingPin", "Orange", 
Fields!Style_Name.Value = "Jack Hammer", "LimeGreen",  
Fields!Style_Name.Value = "Libertine Black Ale","#7e000000", 
Fields!Style_Name.Value = "Hardcore IPA","MidnightBlue", 
Fields!Style_Name.Value = "Cocoa Psycho", "Indigo", 
Fields!Style_Name.Value = "Elvis Juice", "Red")

Answer 1

Просто добавьте в конце True, "Yourcolor"

  =SWITCH(
Fields!Style_Name.Value = "Vagabond Pale Ale", "CornflowerBlue",
Fields!Style_Name.Value = "This Is Lager", "Orange", 
Fields!Style_Name.Value = "Punk IPA", "#00AFDB", 
Fields!Style_Name.Value = "Nanny State", "White", 
Fields!Style_Name.Value = "Jet Black Heart", "DimGray", 
Fields!Style_Name.Value = "Dead Pony Club", "SeaGreen", 
Fields!Style_Name.Value = "5am Red Ale", "Maroon", 
Fields!Style_Name.Value = "KingPin", "Orange", 
Fields!Style_Name.Value = "Jack Hammer", "LimeGreen",  
Fields!Style_Name.Value = "Libertine Black Ale","#7e000000", 
Fields!Style_Name.Value = "Hardcore IPA","MidnightBlue", 
Fields!Style_Name.Value = "Cocoa Psycho", "Indigo", 
Fields!Style_Name.Value = "Elvis Juice", "Red",
**True, "Black"**
)