I'm trying to figure out how to compare three measures, two at a time using parameters and maintain the number formatting of each measure. For example, if I want to display Sales and Order Quantity, Sales will be displayed as currency and Order Quantity as a standard number format. If I change Order Quantity to Profit, I want Profit to display as currency, etc.
Can the number format be defined in the calculation for each parameter? A bonus would be to change the axis labels as well.
If you have suggestions for a better way to do this altogether, I'd love to know.
Thanks!
Hi Lindsay,
I have changed all marks in your workbook.
it works fine. see image.
I have duplicated your measure compare and measure to fields twise. Changed calc and also changed number format in two calc.
Thanks
sankar
