Forum Discussion
Slicers and Filtering
Hi I have had a request from a work collegue to be able to filter by the value selected in the slicer and a defualt value. e.g. slicer has A B C D E in it The selection is C which will fi...
Try this :
Filtered_Data =
VAR SelectedValue =
SELECTEDVALUE('Your_Table_Name'[Column_Name]
)
RETURN
FILTER( 'Your_Table_Name', 'Your_Table_Name'[Column_Name]
=
SelectedValue
||
'Your_Table_Name'[Column_Name] = "Z"
)
Thank you for replying.
Would you set this as a measure then add it in to the "Filters on this visual" section