Filtering issue

[StevenT]

Good morning. My report has a matrix visual with a line chart visual below, and whatever I choose in the matrix visual, I want that records details to appear in the line chart.  Works good.

Trouble is, by default when I open up the report, the line chart shows line details for every single record in the matrix.

How do i set it up so that that records that I highlighted in the matrix, and saved the report, upon opening, the cursor is on the record I highlighted in the matrix?  Right now when i exit the tab and return to it, all records show up in the line chart below.

Is there a way where you click on a record in a matrix, the cursor stays on that record when the report is opened or you move off the tab and return to it?

Thanks, Steve.

[StevenT]

This seems to be a good alternative. Thanks!

[speedramps · Accepted solution]

@StevenT 
No, You can not save a report with a matrix cursor  "anchor" to a row, collumn or cell.

Howver you could use the the HASONEVALUE to determine a roe, column or cell had been selected.

Then eitjer display your measure or a default value.

For example ...

IF ( HASONEVALUE(yourtablename[yourcolumnname],

[yourmeasure],

[defaultmeasure]
)

Please click thumbs up for this helpful suggestion.

Also click accept solution if it works.

Thank you