Forum Discussion

sridevi's avatar
sridevi
Icon for Helper I rankHelper 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

bullius's avatar
bullius
Icon for Helper V rankHelper V
9 years ago

Hi,

 

I don't know if you have tried this, but adding "Platform" to the page or report level filter sections, then filtering out all but Monospace should filter the slicer.