locked
What can a slicer be used on? RRS feed

  • Question

  • Can a slicer be used in a range? Can a slicer be used in an excel table that is not a pivot table?

    Thursday, October 26, 2017 1:08 AM

Answers

  • Hi Saly,

    Thanks for your question.

    >>>Can a slicer be used in a range? 
    As far as I know, we can not do so in EXCEL, but you can achieve this by using Power BI for number and date data types.

    >>>Can a slicer be used in an excel table that is not a pivot table?
    Yes, it can. See below image:


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Thursday, October 26, 2017 8:20 AM