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