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

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

     

4 Replies

  • 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. 

      • 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