Forum Discussion

andrecavaca's avatar
andrecavaca
Advocate II
10 years ago
Solved

Visual level filtering for slicers

I have a large set of options from which I would like to pick some specific ones and use them in a slicer to filter my data. Why Is it not possible to add a Visual level filter for a slicer when thi...
  • austinsense's avatar
    austinsense
    10 years ago

    There is a hack for this ...

     

    1. turn the visual into a bar chart

    2. apply the visual level filter

    3. turn the visual back into a slicer

JeffreyLeiseth's avatar
JeffreyLeiseth
Regular Visitor
7 years ago

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