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.
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".
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".
Reorder Measures.twbx 10.2 KB
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.
1 of 1 people found this helpful
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!
Thank you Matthew for the info shared. I will look into it.