5 Replies Latest reply on Feb 26, 2014 9:53 AM by Akshay Thanai

# Reorder Measure and Dimesions columns

Hi Guys.

How can I show a measure Column before the Dimesnion column ??

Suppose in the below Table, The "Result" field is a Measure and other two dimensions.

How can I show Result before Duration ?

JobDuration Result
ABC2:00:00Success
XYZ3:00:00Fail

Changing the Result (Measure) into a dimesnion won't help as it has been purposely set as measure due to the below issue.

It might be a foolish question , but an answer would help.

Thanks

Akshay

• ###### 1. Re: Reorder Measure and Dimesions columns

Making the measure discrete rather than making it a dimension may help here.  If you have a packaged workbook, and can explain all of your end goals/requirements, we can try to help.  I hate to start providing advice without knowing all of your final requirements.

If you can use the packaged workbook in your other thread to mock up an example, and tell us what you'd like to change about that, we can probably provide prompt help for you.

• ###### 2. Re: Re: Reorder Measure and Dimesions columns

Matthew,

Apologies, couldn't upload the workbook as it had Organisational private data. I have attached a sample one now.

Let's say I have all Text Dimensions. i.e. "Job","Duration","Success".

As I had to show Success in Green and Fail as Red, I converted the the Duration dimension to the measure as suggested by Jarek Sobanski on Conditional Color formatting based on text .

I want to show the data as...

 Job Result Duration ABC Success 1:00:00 XYZ Fail 2:00:00 PQR Success 3:00:00

Here if you notice, Result( A Measure) is to the left of Duration(A Dimesnion).

I am not able to arrange "Result" before "Duration".

• ###### 3. Re: Reorder Measure and Dimesions columns

http://community.tableau.com/docs/DOC-1072

Tableau can only color what is in the "Pane" or on the "Label/Text" shelf.  So, you won't be able to color just the middle column, unless you use two sheets on a dashboard, or a multiple axis crosstab as described at the link above.

• ###### 4. Re: Re: Reorder Measure and Dimesions columns

Here's your example with two sheets used to get the result you want:

This has its limitations, of course.  The other option is to study Jonathan's workbook and try your hand at the Multiple-Axis Crosstab (that has limitations as well--the link above will provide you with all the details you'll need). I'd suggest studying that workbook anyway, as there's a ton of great info in there on all kinds of formatting options in Tableau.  Make sure to download it and view it in Desktop, so you can read the full captions/instructions and view the work.

Cheers, and good luck!

1 of 1 people found this helpful
• ###### 5. Re: Re: Reorder Measure and Dimesions columns

Thank you Matthew for the info shared. I will look into it.