Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Is there a way to adjust the Fiscal Year settings to a Date Hierarchy slicer in Power BI Desktop?
I have the below:
Above, it gives standard FY layout.
But I need this to reflect our internal FY layout of March 1st to February 28th.
There currently is not FY table in the dataset.
I created this dataset from our CRM database in out Dynamics dataverse.
Thank you!
Nat
are you able to use DAX to create column? if you can do that ,you just need to create new columns for fiscal year and replace the origial date column with new ones.
fiscalyear = if(month('Table'[Date])in {1,2},year('Table'[Date])-1,year('Table'[Date]))
fiscalmonth = if(month('Table'[Date])>=3,month('Table'[Date])-2,month('Table'[Date])+10)
Proud to be a Super User!
User | Count |
---|---|
101 | |
90 | |
83 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |