Create Dynamic Periods for Fiscal or Calendar Dates and Dynamic Month Names for Charts
09-06-2016 22:27 PM - last edited 03-16-2017 17:02 PM
09-06-2016 10:27 PM - edited 03-16-2017 05:02 PM
For this data story, my first goal was to be able to create any Date Period that was required for the data. As with the example we have creaated a few simple Periods "CY-LY" (Calendar Year - Last Year), "CY-YTD" (Calendar Year - Year to Date). And in doing so, it gives the user the ability quickly slice their data by the defined period.
Second to this I also created a solution in which the Month Names would dynamically change to either the Fiscal Months (If a Fiscal Period was selected) or Calendar Months (If a Caleandar Period was selected).
So in the report if you click on "CY-YTD", you will see that the dates follow "Jan-May"
Whilst if you click on "FY-LY", you will see that the dates follow the Fiscal Periods "Nov - October"
The final part of the data story is that using the Periods, it makes it very easy to create Calculated Measures based on your custom periods. And his is a lot easier and quicker when your custom periods do not have built in DAX functions.
In doing so that this does is it enables the user to have the ability to quickly and easily slice their data based on custom periods.
I have also published a blog post in terms of how I achieved this.
09-07-2016 12:07 AM
Nice Dashboard, really like the feature which allows to select the unit of measure and the different date periods. By the way, on Page 4 there is a breakdown tree. Is it possible to share the visualization, I was searched for this since Performance Point.
09-28-2016 09:02 AM
Very nice report. Thanks for the blog post too. May I ask what's the KPI like visual u use on page 3? Where can I find it?
09-28-2016 02:45 PM
Thanks for the kind words. And the visual on page 3 was done by a 3rd party developer.
You can contact him on email@example.com his name is Nick Savenko
10-08-2016 12:08 AM
Very good dashboard and financial calender is what a lot of companies use.
What did you use to publish this dashboard into a webpage.
I am new to this environment.
10-08-2016 12:17 AM
I am glad you found it useful. I do also have a blog post and pbix file explaining how I achieved this.
The feature is called publish to web after you upload your Power BI desktop file to the Power BI service. You can then click on file and then Publish to Web.
Just note that when you publish to web it is available for anyone who has access to the link.
07-11-2017 04:13 AM
let TodaysDate = Date.From(DateTimeZone.FixedUtcNow()), YearText = Number.ToText(2000), FiscalStartMonth = Date.Month(Date.FromText(“”&YearText&”-“&#”Fiscal Start Month”&“”)), FiscalStartMonthDay = Date.Day(Date.StartOfMonth(Date.FromText(“”&YearText&”-“&#”Fiscal Start Month”&“”))), FiscalEndMonth = Date.Month(Date.FromText(“”&YearText&”-“&#”Fiscal End Month”&“”)), FiscalEndMonthDay = Date.Day(Date.EndOfMonth(Date.FromText(“”&YearText&”-“&#”Fiscal End Month”&“”))),
where did he edit this, =_= I don't know where I couldn't replicate the example =_=