Slicer to change data used on all tables and graphs

[flyingmada]

I have a table with multiple columns where there are "Raw" or "Cleaned" values. These will represent the same location in each visualization but would like to select between the two with a slicer. When selecting the "Raw" or "Cleaned" slicer option, the connected tables charts will adjust based on the related columns. Example of table is below.

[PaulDBrown]

@flyingmada 

An alternative method is to use bookmarks with buttons. (You can keep the slicer values)

[Greg_Deckler · Accepted solution]

@flyingmada - You will have to either do the switching in your measure or you can unpivot the columns. The second approach is generally not recommended for unpivoting measures. In a measure it is something like:

Measure =
  VAR __Selection = MAX('Slicer'[Column])
RETURN
  SWITCH(__Selection,
    "Raw",SUM('Table'[Raw]),
    "Clean",SUM('Table'[Clean])
  )

[flyingmada]

What does the

('Slicer'[Column])

in your forumula represent?

Am i referencing the slicer? If so, how do I do this?