Toggle button in Power BI

Question

I had a question regarding the Toggle button

1. I have slicers active and inactive
2. cities that are active and inactive

I am trying to select the Toggle button ON and it's not showing the active sites

Answer 1

Hi Try to use this formula:

Column =
SWITCH (
    TRUE (),
    'Table'[Field1] = "AAA", "ON",
    'Table'[Field1] = "BBB", "OFF",
    SEARCH ( "CCC", 'Table'[Field2], 1, 0 ) = 1, "ON",
    'Table'[Field2] = "DDD", "ON",
    "UNKNOWN"
)

For more deep information on Power BI, register for this Power BI Training