Forum Discussion

AMBP1973's avatar
AMBP1973
Helper III
10 months ago
Solved

Show Filtered value on page

Hello,   I am lloking to filter out a single value on all pages by default: 'Training Module' (see below values). Then provide an option through a tile slicer or button to select to include this va...
  • Joe_Barry's avatar
    10 months ago

    Hi 

     

    As a standard why don't you add a Select All option to the slicer, then Select All and then untick the Training module option and publish, and this will be the standard setting for this filter. End Users can then click on it if they want to have Training Modeule included

     

    or

     

    1. Create a table called Calc Table and add columns ID and Calc
    2. in The ID Column add 1 and 2
    3. In the Calc Column add the Text in the 1 row " Not Incl. Training Module" and in the 2 row, "All"
    4. I presume you are using a meadure in the visual? Keep the Original Measure and then also create this
      Not Inkl.Training Module = CALCULATE ( [EXISTING MEASURE], KEEPFILTERS ('YourTable'[Type] <> "Training Module") )​
    5. Then create this measure 
      Switch Measure = SWITCH ( MIN ('CalcTable'[ID] ), 1, [Not Inkl. Training Module], 2, [EXISTING MEASURE] )
    6. Create a Tile slicer and add the Calc column to it and choose single select
    7. Remove the old measure and add your new Switch Measure to the visual. 
    8. Keep all filters clear in the Type slicer and use the Calc slicer instead

    Thanks

    Joe 

  • MFelix's avatar
    10 months ago

    Hi AMBP1973 ,

     

    What I was able to do with a similar need was to create a button slicer and then format it in the folllowing manner:

    • Create a button slicer
      • Add your column to the button slicer
      • Select all values except the Taining module (on my example I have the category a)
      • Filter out  the slicer to only show the category a
    • Add a regular slicer (or any other type of slicer) 
      • Add the column you need
    • Turn off interactions:
      • Regular slicer to button slicer

    Has you can see now you have a button where you can include the other value has you need:

     

     

    Button slicer should look like this before filtering: