Allowing users to choose any two different metrics to compare in a single chart with calculation groups.

Each calculation item is altered with the same conditional logic using ISSELECTEDMEASURE()
Conditional logic addedto the Sales Amount Calculation Item
The same logic added to the Margin % Calculation Item
Add a similar logic to the format string expression
Logic for the format string expression
Create new Calculation Group
Select Calculation items and choose Copy from menu
Change the conditional logic in the duplicated calculation group
Change “Metric 1 Measure” to “Metric 2 Measure” for all the calculation items in the second Calculation Group
Make the same adjustment for all calculation items in the duplicated calculation group
Change the format string expressions to “Metric 2 Measure” as well
Add a blank option for users
Disconneted table for data label slicer

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store