Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Base 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
Super User
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.

Not Solve this Solution 

 i need This way     Please help me   my slicer date  11 July Selected  data show  12 July nut i need  7 july data show  3316 



Change your slicer type to "Before"

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors