When trying to create a dynamic slicer to always default to a "current" date value (such as date/month/quarter/yearetc.), the current solution for this is to create a calculated column against the date value that looks up if it is in the current state. Then, you add a text field to this column to say something like "Current Date", otherwise return the date value. When this column is used a slicer, you can always have the text value of "Current Date" as the default selection and every other value in the slicer shows the factual date value.
A proposed to solution to this for when you don't want to display a text field but always want the current date value selected is to add a slicer option that always defaults to the first value in the list, either sorted ascending or descending.
This eliminates the need for having to create a column that has a text field to flag the current date value.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Markdown documentation item in Workspace
We create documentation in our Git repo. This is useful documentation and project context for humans and AI. The documentation is simply a directory (hierarchy) of markdown files in the Git repo. P...frithjof_v2 hours agoCommunity ChampionNew11Views0likes1CommentAllow creation of Alerts for KPI visual on change % in Power BI Dashboards
Currently, Power BI dashboard alerts for KPI visuals can only be configured against an absolute KPI value. In many business scenarios, stakeholders are more interested in variance to target than the ...SevsBo2 hours agoResponsive ResidentNew8Views0likes0CommentsRecuperar el zoom en la Nueva experiencia de Power Query
En Power BI Desktop 2.158.1177.0 (septiembre de 2026), al activar la característica de vista previa "Nueva experiencia de Power Query", dejan de funcionar los atajos de zoom (Ctrl+Shift++, Ctrl+Shift...apgy45672 hours agoNew MemberNew3Views0likes0CommentsEnable Interactive Editing and Fabric PySpark Execution for Git-Synced .Notebook Folders in VS Code
Allow *.Notebook/notebook-content.py from Fabric Git repositories to open in VS Code’s interactive notebook editor. Permit users to select a Fabric workspace, lakehouse and environment as runtime con...anuragsingh42662 hours agoNew MemberNew4Views0likes0CommentsFabric Local Artifact Validation in VS Code
Fabric artifacts can be authored as code through Git, APIs, CLI, and MCP, but they still need to be published to a Fabric Workspace before they can be fully interpreted and validated. This is especi...ryomaru082511 hours agoAdvocate INew24Views2likes0Comments