Forum Discussion
Matrix/table visual - always focus on current date
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?
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.
4 Replies
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.
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.