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

  • sridevi's avatar
    sridevi
    Helper I
    9 years ago

    Hi asocorro,

     

    Thanks a lot for your suggestion. I have implemented as per the below link information. Yes it was working fine but problem here is its creating new table with all the columns and filtering based on platform which I have specified in search. Its simply creating dupliate of table with filered data. My table has morethan 1000 columns so its recreated again same data set. It may be occupied lot of storage memory. Is that any other way to do filtering?

     

    Thanks in advance.

     

    Regards

    Sridevi