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

     

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. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    wjenkins3811
    Frequent Visitor
    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"
    )