Forum Discussion
Highlight a specific bar/data point on specific date in a (tooltip) trendline
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.
- Make a tooltip page with a barchart
- X-axis [Date] and Y-axis [# Type]
- 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.
- Selecting the tooltip page on the outlier table.
- 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