We are using the Sample - SuperStore dataset for this example. Lets take three measures: Sales, Profit and Quantity. We are creating a parameter to let the user select a measure name and the value on the viz changes dynamically based on the user selection. Next step is to create a calculated field to display the measure dynamically. Now comes the issue. Calculated field can be formatted only one way: it can either be a currency or a number.

Preface: This is a long-overdue travelogue post. This is a sequel to the post titled “THE ONE WITH THE HOBO, THE TREE MAN, THE HUNGRY HOG, MR. VERTIGO AND THE HEADMASTER” which I published on WordPress in early 2017. I thought I lost my draft notes from the trip, but recently found it when I was looking through one of my notes applications. Posting it verbatim. Date: May 26, 2017 at 5:41:16 PM EDT Weather: 55°F Mostly Cloudy Location: I-295 N, Freeport, ME, United States Another last moment trip.