Showing Text Mark Type for Grand Total and Other Chart for Measures

Published: 13 Jun 2017
Last Modified Date: 20 Jul 2023

Question

In a view that contains multiple measure values and a grant total formatted as a horizontal bar chart, how to remove the bar chart for the grant total so that only the label appears while the rest of the view keeps the horizontal bar chart.

Environment

Tableau Desktop

Answer

The following resolution applies to the attached example workbook NoMarkTypeTotals.twbx. Please note that such steps will need to be adjusted for certain views that place measure on rows shelf or contain more than a single dimension. For example, the table calculation would need to be computed differently depending on the table layout.

For each measure appearing in the view as a grand total:

Create a new calculated field similar to the following examples:

IF SIZE()= 1 THEN 0 ELSE SUM([Sales]) END

IF SIZE()= 1 THEN 0 ELSE SUM([Quantity]) END

IF SIZE()= 1 THEN 0 ELSE SUM([Profit]) END

Drag these new calculated field to the Columns shelf to replace the existing measures.
Right click them and select Compute Using > Table (down).
For each new measure's Marks card, add the original measure to Label.