Highlight a specific bar/data point on specific date in a (tooltip) trendline

[JerryAZ]

Hello,

In Power BI I have a table visualization (see Table visualization 'Outliers') with outliers over a period of about 2,5 years. The outliers are always reported on a specific Date, Product, Type and # Type (count). This table is filtered to only show the outliers, but in the underlying data, there are #Types on every date.

Table visualization 'Outliers'

Date	Product	Type	# Type
16-5-2022	A	Apple	5200
9-5-2022	B	Banana	4000
4-5-2022	P	Pear	2750
17-5-2022	A	Apple	3000
9-5-2022	C	Carrot	2500
23-2-2023	P	Pear	1500
1-1-2023	P	Pear	1450
14-7-2022	A	Apple	2000
23-12-2022	B	Banana	4100

The goal is to display a trend line in a tooltip when you are hovering over these different lines. In this tooltip the history of this datapoint should be shown, but with the specific data point highlighted. So, imagine if you hover over the first line, you would want to see the following visual/trend line.

Figure 1: Wanted situation

So for the first row in the table visualization, for the (context) filter on Product=A and Type=Apple, you see all values (#Type) over the entire period for this combination, where the corresponding outlier line on 16-5-2022 is highlighted in red. (See figure 1)

I've taken the following steps.

1. Make a tooltip page with a barchart
2. X-axis [Date] and Y-axis [# Type]
3. Uncheck the Keep All Filters on the tooltip page, then add the fields you want it to filter by (Product and Type) in the "Add drill-through fields here" section. Right now the tooltip is applying all the values you are hovering on.
4. Selecting the tooltip page on the outlier table.
5. Give the corresponding outlier line/date bar a red color.

I have managed to do this so far, except that the corresponding line/date in the outlier table is highlighted in red (step 5).

Does anyone have a solution how I can achieve point 5?

I hope someone can help me out. Thanks in advance!

Kind regards,

JerryAZ