Need a slicer that will allow switching measure displayed in visuals

[LanaPow]

Is it possible to have a slicer that will show measures and not dimensions?

I have 4 visuals that display revenue measure, i.e. Revenue by country, Revenue by manufacturer, and so on. 

I would like to be able to switch that to say, Units or Price using a slicer. 

i.e. I'd select Units and all these visuals would show Units

Is it possible in Power BI?

[PaulDBrown · Accepted solution]

@LanaPow 

Sure you can.

First you must create a new table (use "Enter Data" option from the ribbon), name the column, type in the values in each row ("Units" , "Price") and give the table a name.

In my example I've called the table "Price or Units Slicer" and the column within "Select"

Make sure there are no relationships created with any other tables in your model.

My example looks like this:

Now create the following measure to switch between the measures you wish to display based on the selection (I have [Average Price] and [Sum of Units] as my switch measures):

Units or Price = IF(SELECTEDVALUE('Price or Units Slicer'[Select]) = "Units"; [Sum of Units]; [Average Price])

Create a slicer on the page using the newly created column/table (in my case it is the "Select" column from the "Price or Units Slicer" table. (I suggest you make this slicer a single select to ensure either is always selected)

In the visual, use the measure you have just created ([Units or Price] in my example). 

And here is the result: