I'm trying to use parameter as a filter. But my data is in 3 different formats - currency, percentage and number. Can I make in some way that the number format on axis changes depending on my filter? Forexample my discounts shows as % but my sales as $? Can I create formula in calculated field to do that?
The only way to do this is to force each number to a string in the calculation, then add your formatting.This may break your output of course. There is an idea here to create a format() or text() type function that would add this functionality: http://community.tableau.com/ideas/1052