Forum Discussion

wjenkins3811's avatar
wjenkins3811
Frequent Visitor
8 years ago
Solved

Filtering

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 L...
  • wjenkins3811's avatar
    wjenkins3811
    8 years ago

    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"
    )

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
wjenkins3811
Frequent Visitor
8 years ago

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.