Filtering

[wjenkins3811]

Hello,

I would like to set up a seperate dropdown to where I can select either Dark Mode or Live Mode. We have several catergories that fall under Dark Mode and the same categories that fall under Live Mode. I already have a drop down labeled Queue Name. I would like a seperate drop down that shows only Dark and Live mode.

Example queue:

Classification - Offsite (Dark Mode)

Classification -  Text

Classification - Title

Classification - Title (Dark Mode)

Seperate slicer i would like 

Dark Mode

LP or Live

[Anonymous]

Create 2 calculated column

Darkmode = IF(Table1[Mode]="Dark",Table1[Calssification_Type])

Livemode = IF(Table1[Mode]="Live",Table1[Calssification_Type]).

This will list the categories in each mode.Then apply slicer on these 2 columns.Hope this is what you are looking for.

Thanks

Raj

[wjenkins3811]

Raj,

Thank you for your response. When looking at the columns using the Data tab, Im only see blank fields for both created columns of Darkmode and Livemode . Here's what i typed in. I shortened the name of my tables. 

Livemode = IF(table_P_CLASSIFICATION[queue_name]="Live Mode",table_P_CLASSIFICATION[queue_name])

Darkmode = IF(table_P_CLASSIFICATION[queue_id]="Dark Mode",table_P_CLASSIFICATION[queue_name])

My apologies I am new to power bi. 

[Anonymous]

You have used Queue id in one formula and Name in another one. Could you please some sample data ? Or you can attach the sample PBI file as well.

Thanks
Raj

[wjenkins3811 · Accepted solution]

I'm unable to put the whole file on here for security purposes however the column labeled queue name is the column I am trying to pull live mode and dark mode. There is nothing to differeintiate live mode other than it being blank. I also updated my formula per your findings but still came out blank.  thanks again

I was able to resolve the issue. Thank you for all your help.

CustomColumn = IF(
ISERROR(
SEARCH("A", TableName[ColumnName])
),
"A",
"B"
)