Your table layout at a glance looked like a table of measures as column. If that is the case, have you tried formatting each measure: right-click on each measure, Field Properties, Number Format
Then, I think you will lay it out as follow:
1. drag Measure Names from Dimensions to Columns shelf
2. drag Measure Values from Measures to Marks/Label
3. drag your dim to Rows shelf
4. put Measure Names in Filters shelf if you want to exclude some of the measures.
The number formatting should follow the earlier setting.
But, lacking info or sample workbook, I am wondering how you get that table. I notice that the values (range and format and meaning) are inconsistent along row and column.
To give more idea about my problem I have a snapshot of the sheet i am working on.
To illustrate my problem,
I want :
Actual- GM% = 30%
Actual- IMU%= 33%
vLY(BPS)- GM%= 200( without 2 decimal places). Similarly , I want the whole row vLY(BPS) and vPlan(BPS) to have whole numbers (without decimals)
Actual- Turns= 8.15 ( having 2 decimals)
My above requirements result in having different formatting of adjacent cells in a table.
The data is imported into the tableau in this format only.
Is there a workaround to it.
Sample.png 212.9 KB
When you are using Measure Names/Measure Values then you only have one Marks card for the whole set of names/values, which limits what you can do for formatting. To get around this, you need to use a multiple axis crosstab. See this workbook for details: http://public.tableausoftware.com/views/conditionalformattingv4/Introduction