Forum Discussion
Show Filtered value on page
- 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
- 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
- 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:
- Create a button slicer
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
- 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