Matrix/table visual - always focus on current date

[Anonymous]

Hi all,

I wonder whether there is a way to make my Matrix/table visual to automaticly focus on the current date.

For example, I made a Supply and Demand matrix that contains the whole year.
Obviously its too much to fit in one window so there is a scrollbar. 
But I don't want my customer to scroll everytime he uses this visual. In the end he will allways want to focus on the current date.

Any suggestions?

[MattAllington]

The way I normally do this is to create a new calc column in the calendar table that returns either the date, or the word "today" with a formula equating the date column to today()

eg

if(cal[date]=today,"today",cal[date])

then sort it using date. 

then add it to a slicer (or filter in the filter pane) and select "today". Each time the report refreshes, the calc column updates to the new day. 

[Anonymous]

Hi Matt 
Thank you for your answer.

If I understand you correctly your suggestion wil always show me one row - "Today"
But I want to show all the dates. The future and the past but only focus the view on today.

[MattAllington · Accepted solution]

You cannot control the focus of a visual like this. You can set a slicer and it will remain selected with "today". Maybe you could use a similar technique to select the last 7 days, and allow the user to select a different period if needed from a slicer. 

[Anonymous]

Ok
Thank you