Forum Discussion
One Slicer multi select for multiple columns
Hi I am trying to make one slicer so the result shows ISO 9001, ISO 14001 and ISO 45001 columns All coumns shall be shown as this, but if ex. ISO 14001 is selected, the table only show the 3 last s...
SELECTEDVALUE will only work if your slicer is single selection only, otherwise if you have multiple items in the slicer checked it will return BLANK() by default unless you specify an alternate value in the optional second clause.
Try using CONTAINS to check if a given standard is included in your slicer selection.