Line chart in the report page tooltip

[subhendude]

I have a dataset where I'm storing the response and latency of the APIs like

Now I've used a matrux table to pivot the data and able to do so

After that I would like to display a line chart with the latency trend for last few days in a tooltip. So I used a report page tooltip. I was able to show the report in the tooltip but it always show a single data value in the line chart and not the trend with few past dates.

Can anyone please help how to show a line chart and formulate the dataset for the line chart report with the filtered data while hovering over the cell in the matrix table?

[Anonymous · Accepted solution]

Hi @subhendude ,

Here I suggest you to create an unrelated date table to help you create a line chart.

Measure = 
IF(MAX('DimDate'[Date]) <= MAX('Table'[Date]),CALCULATE(AVERAGE('Table'[Latency])+0,FILTER('Table','Table'[Date] = MAX(DimDate[Date]))))

Result is as below.

Best Regards,
Rico Zhou

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