The new date slicer is awesome, but it would be so nice if you could set a dynamic date selection instead of a static. With a static filter the user will always have to set the dates before the saved...
labry
6 years agoNew Member
This is easily achievable with custom report date attributes. For example, add a column to your date table named ReportMonth. When processing your date table always make ReportMonth equal to MonthName, except for the current month which has a value of "Current". Then save your reports with "Current" in the ReportMonth filter. Every time you refresh your report will be pointing to the current month. You can use this same method for other types of reporting periods.
Recent ideas
Dynamic current-period defaults for separate Year and Month slicers
Scenario The target scenario is a report viewed in Power BI Service, using a DirectQuery semantic model and a dedicated Date dimension. Separate Year and Month slicers are part of the required user ...vvargasv16 hours agoMicrosoft EmployeeNew9Views0likes0CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf22 hours agoFrequent VisitorNew74Views3likes3Comments