Forum Discussion

sridevi's avatar
sridevi
Helper I
9 years ago
Solved

Need help to do filter in slicer data

Hi,   I want to show my data based on my filter values in slicer visualization.  I have platform column in my table. I want to show this platform data in a slicer visualizations and it shows only M...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi sridevi,

     

    You can use "SELECTCOLUMNS function" to choose the columns which you need:

     

    I added to new columns to base table:

     

    Use "SELECTCOLUMNS" to filter other columns:

     

    Table = SELECTCOLUMNS( FILTER(Table1,ISERROR(SEARCH("Monospace 500",Table1[platform]))=FALSE()),"Platform",[Platform])

     

    In additon, allexcept function also worked.

     

    Table = CALCULATETABLE(ALLEXCEPT(Table1,Table1[Column],Table1[Column 2]), FILTER(Table1,ISERROR(SEARCH("Monospace 500",Table1[platform]))=FALSE()))

     

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi sridevi,

 

You can use below methods to filter the data in slicer:
1. Page level filter(bullius’s point of view):


 

2. Query editor filter rows:


 

3.Dax search function.

Table = FILTER(Table1,ISERROR(SEARCH("Monospace 500",Table1[platform]))=FALSE())

 


Regards,
Xiaoxin Sheng

 

sridevi's avatar
sridevi
Helper I
9 years ago

Thanks a lot for all of your responses.

 

Yes I knew about page and report level filters and I used in my usecase aswell. But here I dont want to apply this filter in page and report level. I have arleady PLATFORM data column in slicer visualization format and I need to filter only monospace 500 related products for one of my usecase. I have many slicers in my page so I apply page level it should be affected my other slicers and charts. So Its not appropriate for my requirement. I need to apply filter only my platform slicer.

 

If I use page and report level filters and query editor filters then it will be affected my whole report and report might be wrong.

 

Anonymous: Thank you for your suggestion. I have created new table with the help of DAX query but problem is here, it has all other columns as well. I want to have only platform data with use of DAX syntax for filtering monospace 500. Is that any other way to generate only platform column in new table or shall I have filter it existing table which has platform field for this particular silcer.

 

Thanks a lot for all of your suggestions.

 

Regards

Sridevi

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi sridevi,

     

    You can use "SELECTCOLUMNS function" to choose the columns which you need:

     

    I added to new columns to base table:

     

    Use "SELECTCOLUMNS" to filter other columns:

     

    Table = SELECTCOLUMNS( FILTER(Table1,ISERROR(SEARCH("Monospace 500",Table1[platform]))=FALSE()),"Platform",[Platform])

     

    In additon, allexcept function also worked.

     

    Table = CALCULATETABLE(ALLEXCEPT(Table1,Table1[Column],Table1[Column 2]), FILTER(Table1,ISERROR(SEARCH("Monospace 500",Table1[platform]))=FALSE()))

     

     

    Regards,

    Xiaoxin Sheng

    • sridevi's avatar
      sridevi
      Helper I
      9 years ago

      Anonymous,

       

      Thanks a lot for this suggestion. It was working fine as you suggested.

       

      Regards,

      Sridevi