Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
shri0025
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.

Sampledata 

 
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 3
lbendlin
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.

lbendlin_0-1686535741129.png

 

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 

shri0025_0-1686548593780.png

 

Change your slicer type to "Before"

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.