Forum Discussion

Wiene24's avatar
Wiene24
Icon for Helper II rankHelper II
7 years ago
Solved

Smart Slicer

Hi,   Is it possible to make a slicer smarter?   I have a database with clients and with invoice amounts.   I have a slicer with years, but now I want that the slicer where I can select a certa...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Wiene24,

     

    The custom visual "HierarchySlicer" is the solution. It has a Value filed where we can add a measure to filter the values. Please refer to the demo below. Some items are filtered out by the measure. 

    SlicerOnly =
VAR temp =
    SUM ( Sales[SalesQuantity] )
RETURN
    IF ( temp >= 100000, temp, BLANK () )

    Smart-Slicer2

     

    Best Regards,
    Dale

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

There may be something in the marketplace in terms of a smarter slicer but I'm not aware of a way to do that because you can't use filters on a slicer and you can't use measures as filters in page or report filters.