How To Avoid Labels Overlapping Each Other While Showing All Labels In Line Chart Using Shapes

發佈時間 : 10 Apr 2020
上次修改日期 : 01 Sep 2023

問題

How to avoid overlapping labels while showing all the labels without moving them manually

For example:

User-added image

Desired:

環境

Tableau Desktop

答案

To follow along with the below solution, please see the sample package workbook in the Attachments section.

1. Create the following calculations

Label1 with the following formula:
IF INDEX()%2=1 THEN ATTR([Category]) END

Label2 with the following formula:
IF INDEX()%2=0 THEN ATTR([Category]) END

2. Drag the calculated fields created above to Label on the Marks card

3. Click Label > Text ... to edit the label as shown below:

<AGG(Label2)>
*Enter*
*Enter*
*Enter*
<AGG(Label1)>

User-added image