topic Re: Show Filtered value on page in DAX Commands and Tips

Show Filtered value on page

AMBP1973 — Wed, 22 Oct 2025 05:01:01 GMT

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

Re: Show Filtered value on page

Joe_Barry — Wed, 22 Oct 2025 08:07:45 GMT

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

Create a table called Calc Table and add columns ID and Calc
in The ID Column add 1 and 2
In the Calc Column add the Text in the 1 row " Not Incl. Training Module" and in the 2 row, "All"
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") )
Then create this measure
Switch Measure = SWITCH ( MIN ('CalcTable'[ID] ), 1, [Not Inkl. Training Module], 2, [EXISTING MEASURE] )
Create a Tile slicer and add the Calc column to it and choose single select
Remove the old measure and add your new Switch Measure to the visual.
Keep all filters clear in the Type slicer and use the Calc slicer instead

Thanks

Joe

Re: Show Filtered value on page

MFelix — Wed, 22 Oct 2025 08:24:42 GMT

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:

Re: Show Filtered value on page

v-kpoloju-msft — Thu, 23 Oct 2025 08:37:57 GMT

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.

Re: Show Filtered value on page

v-kpoloju-msft — Sun, 26 Oct 2025 13:23:46 GMT

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.

Re: Show Filtered value on page

Rufyda — Mon, 27 Oct 2025 13:19:39 GMT

We're here in the community to support each other.

Re: Show Filtered value on page

AMBP1973 — Fri, 31 Oct 2025 02:40:36 GMT

thankyou everyone Rufyda v-kpoloju-msft MFelix Joe_Barry certainly appreciated your assitance with this. Many thanks