Matrix with Date Columns and Tooltip with Date Range

[Mark_B]

I would like some help with a custom tooltip for a matrix.  I've seen this question asked in different ways, but not quite like what I am looking for.

I have a matrix with several row headers (#, Metric, Measurement, Goal), and column header is a Date field.  The value in the matrix body is a metric value (number).  I am looking to add a tooltip that shows a clustered column/line chart combo that shows displays the metric values over a date range ( previous six weeks this year, and previous six weeks last year).

I have the clustered column/line chart set up on a tooltip, but when the matrix is linked tooltip, the tooltip is sliced by all column and row headers, leaving my tooltip with a single bar and a dot from the line graph.

Is there a way to expand the date range to match my tooltip (maybe slice by row headers but not column headers)?  I've tried different filters on the tooltip, but I feel like the issue is with the matrix.

Thoughts?

Screenshot - Basic Matrix

Screenshot - Basic Matrix and tooltip sliced by row headers AND the single date field

Screenshot - what the tooltip shoud look like for the date above.  Clustered column/line chart sliced by row headers, but with 6 week range.

[dax · Accepted solution]

Hi @Mark_B , 

Based on my test, I find that the tooltip in Matrix only in values, it couldn't use on Row or Column Header. And when hover over on it , it just filter on sepcific date value instead of date range. So your requirement might not be achieved currently.

Best Regards,
Zoe Zhi

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

[Mark_B]

Thank you for the confirmation, @dax Zoe Zhi!