Show Filtered value on page

[AMBP1973]

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

[v-kpoloju-msft]

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.

[MFelix]

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:

[Joe_Barry]

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