Categorize few labels to one option and use it in slicer.

[Polo87]

Hi,

I have a case where I need to filter by labels However I need only WON, Lost and Others(Pending) which contains all other labels.
How Could I achieve it?

[Polo87 · Accepted solution]

@PowerBigginerHow could I modify it to exclude "Cancelled" label from Pending group? So it should content all labels except WON, LOST and Cancelled

LabelsGroup = 
SWITCH(
    TRUE(),
    'RequestTable-Splitted'[Planner_Labels] = "WON", "WON",
    'RequestTable-Splitted'[Planner_Labels] = "Lost", "Lost",
    'RequestTable-Splitted'[Planner_Labels] = "Cancelled", BLANK(),
    "Pending"
)

Will it work as I described?

EDIT: It will create Blank option with Cancelled label. How to hide it 🙂

[PowerBigginer]

Create New column in your table 

NewLable = SWITCH(TRUE(),tablename[Win_Status] = "WON","WON"
,tablename[Win_Status] = "Lost","Central","Pending")
Use this column in slicer

If it helps, Please Mark as a solution!

For more Power BI Tips & Trick visit my blog https://powertipstricks.blogspot.com/

Thanks In Advance!

[Polo87 · Accepted solution]

@PowerBigginerHow could I modify it to exclude "Cancelled" label from Pending group? So it should content all labels except WON, LOST and Cancelled

LabelsGroup = 
SWITCH(
    TRUE(),
    'RequestTable-Splitted'[Planner_Labels] = "WON", "WON",
    'RequestTable-Splitted'[Planner_Labels] = "Lost", "Lost",
    'RequestTable-Splitted'[Planner_Labels] = "Cancelled", BLANK(),
    "Pending"
)

Will it work as I described?

EDIT: It will create Blank option with Cancelled label. How to hide it 🙂

[PowerBigginer · Accepted solution]

in filter section you can apply not to show blank