Forum Discussion

erhan_79's avatar
erhan_79
Icon for Post Prodigy rankPost Prodigy
7 years ago
Solved

Chiclet slicer blank data

Dear All ;

 

İ created chiclet slicer visiual but on this visual "Blank" data is comint too.How can i delete in this slicer that blank data , i just want that  filter "16" seem.

 

thanks

 

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi erhan_79

     

    The first way: Add a page level filter to set the column is not blank.But it might effect the whole report data.

    The second way: Add a hidden slicer which is used to filter the visible one.You may refer to this video.

    Regards,

    Cherie

     

3 Replies

  • PattemManohar's avatar
    PattemManohar
    Icon for Community Champion rankCommunity Champion
    7 years ago

    erhan_79 Please try to create a calculated table with the field that needs to be used in the slicer along with the Key column. Use this key column to make a relationship with the main table. 

     

    Test164Out = FILTER(Test164,NOT(Test164[Data]=BLANK()))
  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi erhan_79

     

    The first way: Add a page level filter to set the column is not blank.But it might effect the whole report data.

    The second way: Add a hidden slicer which is used to filter the visible one.You may refer to this video.

    Regards,

    Cherie