Forum Discussion
Microsoft EmployeeLine chart in the report page tooltip
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?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.