Tooltip lable repeating in Line and CLustered Column chart

[sanjan1812]

[rajendraongole1 · Accepted solution]

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.

[rajendraongole1 · Accepted solution]

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.

[Anonymous · Accepted solution]

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.

[sanjan1812]

This is a shorter method. Will try to implement this as well! Thank you!!

[sanjan1812]

Thank you @rajendraongole1. I have highlighted the column in the table below that needs to be displayed. It would be of great help if you can help me with a solution.

Year	Region	Rev	Emp	Inc	Loss	Part. Rate
01-01-2018	A	$      49,324	3,015.00	$  531.00	3.8%	60%
01-01-2019	A	$      51,344	3,084.00	$  561.00	3.3%	60%
01-01-2020	A	$      49,529	2,951.00	$  589.00	5.2%	60%
01-01-2021	A	$      52,837	3,042.00	$  632.00	2.8%	60%
01-01-2022	A	$      54,376	3,117.00	$  641.00
01-01-2018	Au	$      17,830	1,134.00	$  596.00	2.9%	60%
01-01-2019	Au	$      18,950	1,178.00	$  634.00	2.7%	60%
01-01-2020	Au	$      19,474	1,153.00	$  649.00	4.9%	60%
01-01-2021	Au	$      21,524	1,227.00	$  713.00	2.9%	70%

[rajendraongole1 · Accepted solution]

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.

[sanjan1812]

Thank you for your guideance. Truly appreciate it!!

[rajendraongole1 · Accepted solution]

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.