Forum Discussion
Matrix/table visual - always focus on current date
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.
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.
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.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.
Ok
Thank you