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

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