Forum Discussion

AMBP1973's avatar
AMBP1973
Icon for Helper III rankHelper 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 value i.e. "Select to also show Training Module'. Would someone please be able to assist? I have tried applying the pages filters then adding the folowing to a button will nil success:

 

Selected Training Module =
VAR Selected = SELECTEDVALUE('DI Review'[Type])
RETURN
IF (
    ISFILTERED('DI Review'[Type]),
    SELECTEDVALUE('DI Review'[Type]),
    IF(Selected = "Training Module", BLANK(), Selected)
)

 

many thanks in advance for your assistance

  • Joe_Barry's avatar
    Joe_Barry
    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
    MFelix
    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:

     

     

     

     

6 Replies

  • Joe_Barry's avatar
    Joe_Barry
    Icon for Solution Sage rankSolution Sage
    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 

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Icon for Community Support rankCommunity Support
    10 months ago

    Hi  AMBP1973.

    Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to Joe_Barry, MFelix, for those valuable insights on this thread.

    Has your issue been resolved? If the response provided by the community member Joe_Barry, MFelix, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

    Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

    Thank you for using the Microsoft Community Forum.

     

    • v-kpoloju-msft's avatar
      v-kpoloju-msft
      Icon for Community Support rankCommunity Support
      10 months ago

      Hi AMBP1973,

      Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

      Thank you.

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    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: