Forum Discussion
danzrust
Helper IV
4 years agoDate Filter with Overlapping Preselects (Today, Yesterday, Last 7 Days, Last 30 Days, Last Month...)
I am looking for hints on how to replicate these filter preselects in Power BI: I want to to simply create this as a dropdown filter with no other extra steps for my users. Assume my ...
mahoneypat
Microsoft Employee
4 years agoYou can do that with a Calculation Group. Just create a calculation item for each pre-set date range you want, and then you can use the calculation item name column in your slicer. You will need Tabular Editor to create it, but there is a free version if you are not already using it.
Creating Calculation Groups in Power BI Desktop - SQLBI
Pat