Forum Discussion
Post PatronFilter based on other page selection
Super UserHi ak77 ,
For this I can see two options:
Drill trough: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
Sync Slicers: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers?tabs=powerbi-desktop
Depending on the final result (and looking at your second need) you may need to create a measure that forces the context of the filter.
Let me know if this helps.
ak77Hi Miguel
Thanks for reply. i tried the option and was able to filter out from first condition using sync slicer option. i am still facing issues for 2d filter option. Can u please help with Measure if possible?
- MFelix
Hi ak77 ,
Confirm if my understanding is correct for the second option you want to select for example July 20 2023 and the table should show all the values prior to that date is that correct?
Assuming that you have a relationship between the date table and the table of the effective date you can create a measure similar to this:
Previous date = CALCULATE ( COUNTROWS ( Table), Table[effective date] <= MAX ( 'Date'[Data] ), CROSSFILTER ( Table[effective date], 'Date'[Data], NONE ) )Now add this measure to your table and the result will be the expected one: