@dsilveira wrote:
Thanks @KHorseman
For the moment I'm using your solution, but really I would like work with the timeline because in some moments I like check the sales in the last month or maybe the last year or last week (I would like see in other range of time, BUT I usually check "yesterday").
For that, I would like keep the timeline and its functionalities.
Then just keep the timeline as it is. If you usually check "yesterday", create a measure and put it in an individual visual constantly, then you don't have to check "yesterday" any more. You can check the sales in last week,month,year and it won't affect the "yesterday" visual.
A measure based on a calendar table from @KHorseman would be like
Yesterday Measure =
CALCULATE (
SUM ( yourTable[Column] ),
FILTER ( ALL ( yourTable), RELATED ( DateTable[Day] ) = "yesterday" )
)
