Forum Discussion
shri0025
Helper II
Helper IIBase On Min Date on Slicer Filter
Hi Please hep me i am new on Power
I have a slicer added on the dashboard. In table visual (data coming from transaction table), I want the sales for the previous date to the minimum of SLicer Date. The previous date will be the date on which the salesamount >0.
If Selcted 8 July 2019 min date value THAN Show value 3316 Min Date 8 Jun and data are coming 7 July and Max date selected 20 Dec Than value SHow 1472
3 Replies
- lbendlin
Super User
For this to work you need a disconnected dates table for your slicer, and then a measure that controls which of the rows in your fact table to show.
See attached.
