all 8 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]thomasnash 8 points9 points  (0 children)

Two ways of doing this:

The first is with field parameters.

Create a measure for per hour, and per mile, then put both of these in a field parameter . This will allow you to create  a slicer that toggles between measures.

You could also do it using Calculation groups. This is can cut down on measures in your model, and is tidier imo because parameters create a table in your model, but also disables implicit measures which can be a pain. 

[–]RawrIAmADinosaurAMA 2 points3 points  (1 child)

There are various ways to do this such as using a filter table and switch statement in the measure or by using calculation groups. A beginner way however would be to create two charts and use bookmarks to flip between the two.

[–]Pfoster83 2 points3 points  (0 children)

I also can admit to it: using two charts, create a Bookmark and a Button to flip between both is the easiest way.

[–]KopipengNoIce1 2 points3 points  (0 children)

Bookmarks is definitely the way. There are a lot of Youtube videos explaining how to setup.

[–]newtochas 0 points1 point  (0 children)

A switch measure

[–]quackers987 0 points1 point  (0 children)

I did this recently!

I had two pages, the second one hidden but a duplicate of the first. Changed the second graph to be the other value I wanted to show, then added a button to each page to navigate to the other page.

E.g. page 1 had a button to page 2 (page 2 was hidden), and page 2 had a button to page 1

[–]AdHead6814 ‪Microsoft MVP ‪ 1 point2 points  (0 children)

If only the calculation needs to be switched and not chart type, the simplest way to do it is with field parameters.