cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sue Frequent Visitor
Frequent Visitor

Re: Visual level filtering for slicers

This 'solution' is great if you have only a few visualizations that need interactions to be turned off. It is much more cumbersome of a 'solution' when you have a page of over 30 stacked visualizations. 

bandrathy Occasional Visitor
Occasional Visitor

Re: Visual level filtering for slicers

This was 100% what I was running into with trying to filter down my results in a table. Thanks a lot for the info! Works perfectly

AlexBro Regular Visitor
Regular Visitor

Re: Visual level filtering for slicers

Any news on this topic ?

 

We need that feature a lot of times. Smiley Sad

 

It's really frustrating to see that something so basic is not implemented. I need the filter always to be updated to the current date i.e. all filter options.

Slicer returning ALL rows matching DATE1 OR DATE2 with SELECTEDVALUE

Goal: 1 Slicer returning ALL rows matching DATE1 OR DATE2 with SELECTEDVALUE

Have 1 slicer where a min and max date range is selected and use that to filter such that ALL rows with DATE1 OR DATE2 are returned.  Using two slicers returns only rows with DATE1 AND DATE2 which is why this is not the ideal scenario.

 

Example Details:

Table: CE      (All relevant fields are in this table)

DATE1: CreatedTime

DATE2: caseclosedtime

DATE1 fully qualified reference: 'CE'[CreatedTime]

DATE2: fully qualified reference: 'CE'[caseclosedtime]

 

Steps

  1. Create a new Column

in the function bar replace

Column =

With

CreatedTimeOrCaseClosedTime = SELECTEDVALUE('CE'[CreatedTime],'CE'[caseclosedtime])

Now we have a column that contains a date and will return created date if it is selected in a slicer and if not will return closed date.

  1. Create a slicer
    1. Select a blank  area of the page
    2. Select the slicer visual
    3. Drag the newly created column CreatedTimeOrCaseClosedTime into the empty Filter field
  2. Do something with it because you are done man. Lol
Highlighted
Capstone Member
Member

Re: Visual level filtering for slicers