Data Viz Done Right

March 28, 2017

Tableau Tip Tuesday: How to Use One Parameter With Unlimited Number Formats

8 comments
I've written about this week's tip before, yet never created a video for it. People have been telling me they find the videos useful, so occasionally I'm going back and creating videos for older tips. This is one of those weeks.

In this week's video, I show you how to use a single parameter with unlimited number formats. This is particularly useful when you have a single chart with a single measure and you want you user to be able to swap out the measure, yet retain the number formatting for the measure (e.g., currency vs. percentages).

8 comments :

  1. Good morning Andy,

    as always a very helpful video.
    Is there any way to attach the choosen parameter name to the axis?

    Thank's for your help.

    Cheers
    Holger

    ReplyDelete
    Replies
    1. Yes, just drag the parameter to the columns shelf and place it where you'd like it to appear.

      Delete
  2. Thank you. This exactly addresses something I was currently struggling with. Great post.

    ReplyDelete
    Replies
    1. FYI... I found creating the various calculated field needed using formulas in Excel saves a lot of time.

      Delete
  3. Help me understand why you need 6 calculations? Why can't you just format the original measures (Sales, Profit, Unit price, etc) and use these in the same way? I'm sure I'm missing something but can't figure out what.

    ReplyDelete
    Replies
    1. I need 6 calcs because if I use the origjnal measures, they will display irrespective of what's selected in the parameter.

      Delete
  4. This comment has been removed by a blog administrator.

    ReplyDelete
  5. Thanks Andy
    Very helpful video, one thing i want to ask is that can we change color of chart as we change parameters. For example when we select sales parameter, color of chart should change to blue and when we select profit ratio color of chart should change to green and so on and so forth. Please suggest

    ReplyDelete