It would be very useful if we could set our fiscal year somewhere and have that utilised by charts. This could possibly be done either as a global setting or per chart. Currently to display fiscal y...
Strubkj
Microsoft Employee
6 years agoHi there. While I agree that there should be some easy setting to adjust FY settings other than Jan-Dec, if you are already setting up a date table either that you link to your data set or configure using a calculated table, you can do this quite easily on your own, with just a little DAX. Here is one I use to create a column reflecting my organizations FY (July-June): DateFY = IF(DateKey[DateMonthNumber] > 6, DateKey[CY Year] + 1, DateKey[CY Year]) After setting up a calculated date dimension table with a Calendar Year column and a month number column, you realign your Fiscal Year, as shown above. If you are working with very large datasets, might be best to configure a date dimension table in another source, and connect to it to save on memory consumption. Of course, as calculated column value, you can use it as a filter or use is as your configured Fiscal year, Fiscal quarter, month, and day values in your shared axis of a graph to customize your drill down. It's a bit more complicated than it needs to be, and it would be nice to be able to just adjust the native setting in your Power BI Desktop to have your date values reflect your FY FQ needs, but give the above a try. It works well enough for me!
Recent ideas
Dedicated Fabric Message Center to communicate planned Fabric Changes
Summary Microsoft recently rolled out a change that automatically enabled the Item Recovery tenant setting in Microsoft Fabric for tenants where the setting had not been explicitly configured. Accor...Edgar_6 hours agoNew MemberNew24Views4likes0CommentsWorkspace-Level Control of Storage Modes (Import vs DirectQuery vs Direct Lake)
Organizations operating under strict governance and data residency requirements need the ability to control which storage modes are permitted within a workspace. Currently, report authors can choose...masoodaftab6 hours agoNew MemberNew5Views0likes0CommentsGranular Workspace Permissions Beyond Workspace Roles
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } The current workspace access model is limited to the predefined workspac...masooddevcorp7 hours agoNew MemberNew14Views1like0CommentsAccessibility issue in the Share dialog of embedded Power BI reports
Accessibility issue in the Share dialog of embedded Power BI reports I would like to share an accessibility finding identified while testing an embedded Power BI report published as part of the cont...ugartema10 hours agoNew MemberNew10Views1like0Comments