With the latest May updates, we now have the preview feature of the 'Relative Date Slicer'. We really like this new preview feature, but because of the fact that one essential thing for us is missing, we can't use it at all. It would be great to manually set the start day of calender weeks, because our clients have different calenderweeks. Mostly managed by monday-sunday.
13 Comments
- markus_aalto
Advocate I
I noticed this same thing, very annoying and sad. This should be out of the box feature in my opinion. I mean Power BI is used all around the world. Should have the ISO 8601 as an option! - stefan18New MemberIndeed, it should be an option (preferably one that defaults to the culture used).
- jeremy_smith2New MemberThe DAX "WEEKDAY () " function has a parameter for "return type" that lets us specify whether we want the week to "start" on Monday or Sunday... I would prefer a parameter approach for the relative date slicer as well, because here in USA even though week "technically" begin on Sunday, many organizations still want to evaluate / compare weeks Monday -> Sunday not Sunday -> Saturday. If it "defaults" based on locale, that's fine, but please provide a way to override any locale based defaults. THANK YOU! Reference to DAX WEEKDAY () - https://msdn.microsoft.com/en-us/library/ee634550.aspx
- spuder
Resolver IV
Just to give my two Cents. For me it is mandatory that we can use the relative date filter with weeks from Monday to Sunday. Should not be that difficult. Please give us the option to choose. - jasperaubelRegular VisitorEssential to include the ISO standard for weeks (Mon - Sun)
- paulienNew MemberYes please, our weeks start on monday. My clients cannot properly use the relative slicer now because it gives them the wrong numbers and confuses them. Even though my regional settings should be correct. Also, the option for ISO weeks would be great.
- gorgiNew MemberWe need to choose week start date ASAP. I guess adding it to the "Format" pane of the visual will make most sense.
- bart15New Member'@Power Bi Team, can you tell us when this option will be possible, otherwise we can't use the relative date option because our reporting weeks starts always on mondays, Thanks a lot!
- prakash_michae1New MemberPower BI team, Please add this option. As the ISO week starts on Monday and Slicer week on Sunday some of the data gets cut off . Only acceptable start of the week day so becomes Sunday!.
- pbiideas1New MemberPlease add this option!
Recent ideas
Paste values in slicers for hierarchy data
Hierarchical slicers are widely used in enterprise reports (for example Product RCN > SKU Key, Region > Country > City, or GPP > Division > RCN > SKU). Users often need to bulk-filter by pasting valu...eddieisking20001 hour agoFrequent VisitorNew4Views0likes0CommentsPower Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes3 hours agoNew MemberNeed Clarification203Views3likes2CommentsMake Copilot Approval status for semantic model available through API
In recent versions fabric allowed to mark a semantic model as approved for copilot to reduce AI adoption friction. However there is no specific way for external governance application to analyse whi...FrançoisD3 hours agoFrequent VisitorNew11Views2likes0CommentsClone a workspace, including its data, to a new workspace
Description: Today there's no way to fully clone a Fabric workspace: git sync and Deployment Pipelines move item definitions only, not the underlying data; Warehouse's zero-copy CREATE TABLE ... AS ...gclements5 hours agoHelper IINew13Views1like0CommentsAllow NotebookUtils getSecret() to authenticate with Workspace Identity
Current behavior In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook. This behavior appli...tmihara10 hours agoNew MemberNew8Views0likes0Comments