Tooltip lable repeating in Line and CLustered Column chart

Hi sanjan1812 -If a field is already being used in the "Values" or "Axis" section, avoid adding it again in the "Tooltips" section, as this can cause repetition.Make sure that the fields in the tooltip section of your chart are not duplicated. In the "Visualizations" pane, under the "Tooltips" section, verify that each field is only listed once.

As a temporary workaround, you can try using a different visual that might better handle tooltips for your specific data.

 

Hope the above information helps on repeat label, if still issue exist, please upload the file with sample data will check it.

Hi sanjan1812 - as checked in your shared data, already year column is maintained with Date field, you can rename the year to Date and seperately you can create a year column and use it in fields as like below:

Create a new page in your report and set it as a tooltip by going to the "Page Information" pane.Design the tooltip layout with the fields and visuals you want.Go back to your Line and Clustered Column chart, select the "Tooltip" dropdown, and choose the custom tooltip page you just created.

 

 

Hope this helps.

 

Hi,

Thanks for the solution rajendraongole1 offered, it is excellent, and i want to offer some more information for user to refer to.

and i want to offer some more information for user to refer to.

hello sanjan1812 , based on the picture you have offered,  did you use a date hierarchy and then only put years in the hierarchy, as the following picture is showing.

if your format like this, it will dispaly two year field in tooltip.

1.If you just want to add the year to the x-axis, you can create a new column to just add the year.

Years = YEAR([Year])

Then put  the column to the axis.

2.You can put the date to x-axis, then select date instead of date hierachy.

Output

If the solution rajendraongole1  and i offered help you slove the problem, you can consider to mark them as solutions so that more user can refer to.

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.