In the recent Power BI update, two new options have been added that significantly improve the functionality of the date slicer: “Support for all languages” and “Highlight invalid dates using DAX”. These features allow for greater flexibility and precision in managing dates within reports.
The date picker now offers a modern calendar view, with presets, pop-up mode, default selection, themes, and more. These improvements make it a must-have date slicer for any Power BI report. Plus, its rich formatting options help maintain brand consistency and deliver a seamless user experience.
Main features:
Display Mode: Choose between popup and canvas modes.
Presets: Many commonly used presets such as russia telegram database Today, Last Week, YTD, MTD, or create your own preset using the field.
Default Selection – Controls the date period selected when the user refreshes or reopens the report.
Filter Type: Choose between Range and Start/End types.
Month Style – Select single or double month date slicer.
Multiple Date Ranges – Flexibility to select multiple date ranges.
Themes: 15+ pre-designed themes with full customization.
Holidays and Weekends – Customize the display of holidays/weekends.
Import/Export JSON: Create templates and share your designs.
Invalid Dates – Customize invalid dates in your data or the ability to mark certain dates as invalid via a DAX.
Cycle charts are exceptional tools for visualizing and understanding seasonal patterns in time series. Unlike conventional line charts, which can mask cyclical trends, cycle charts break down data into cycles and present them individually for each period within a cycle.