Forum Discussion

Wiene24's avatar
Wiene24
Helper 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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
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

Wiene24's avatar
Wiene24
Helper II
7 years ago

Hi,

 

When I first started using this slicer it worked even without the Value field.

But I think something changed that it doesn't work anymore, for any of my reports.

I didnt look at the measure yet because I didn't need it. I cant use the VAR temp and Return. They just don't excist.

 

Is there any other way I can make the slicer that smart that it only shows values that are active in the report?