Forum Discussion

hmokkapati's avatar
hmokkapati
Helper II
8 years ago

Issue with Timeline slicer week selection - for Fiscal Year implementation

I have the timeline slicer implemented with below settings.

a) trying to show Fiscal Year (July to Jun)
b) Sunday being the first day of the week

I needed to show Fiscal years on the slicer and not calendar year (supposed I select Aug 2015, needs to show as Aug FY16).

Hence, I added another column using the below DAX and used that for Timeline slicer which would be the exact date after one year. (also as stated here)

TimeLine Slicer Date =
DATE ( YEAR ( DateCalendar[Date] )+1, MONTH ( DateCalendar[Date] ), DAY ( DateCalendar[Date] ))

This works fine at the Yearly/monthly level but unfortunately, not at weekly level. When I select a particular week say W28 of FY16, the days are not being selected correctly : In some cases it selects “Sun to Sat” in some cases “Sat to Fri” (based on the year).

Could you please advise how I can show fiscal dates on the slicer and make it work correctly at all the levels for all FYs. (Attaching the pbix file for reference)

Thank You,
Harish

4 Replies

  • Quaxdachs's avatar
    Quaxdachs
    Regular Visitor

    Same here. I used a debugger to find out, that there are at least 3 functions for the label generation (Month, Quarter and Year).

    The functions look like: 

    n.prototype.generateLabel = function(e) {
      var t = this.shortMonthName(e.startDate) + " " + e.startDate.getDate() + " - " + e.year;
      return {
        title: t,
        text: e.startDate.getDate().toString(),
        id: e.index
      }
    }
    
    n.prototype.generateLabel = function(e) {
      var t = this.quarterText(e.startDate);
      return {
        title: t + " " + e.year,
        text: t,
        id: e.index
      }
    }
    
    
    n.prototype.generateLabel = function(e) {
      return {
        title: "Year " + e.year,
        text: e.year.toString(),
        id: e.index
      }
    }

    As pbiviz files basically are zip files, I decided to download the visual, unzipped it and edtited the code file. 

    I thought, that replacing

     e.year

    by 

    (e.StartDate.getMonth() == 0 && e.StartDate.getDate() == 1)? e.year : e.year+1)

    should work (at least for fiscalyears, that dont start at January 1st). 

    But somehow it seems that this has no effect. After i zipped the files and imported the modified version, I didnt see any change. Is there something like a visal cache?

     

     

    Regards

    Kim

    • v-viig's avatar
      v-viig
      Community Champion

      hmokkapati, This issue has been added to our backlog (#24879).

      We'll investigate it deeper and fix soon.

       

      Quaxdachs, Yes, you're correct. Power BI downloads custom visuals from CDN.

      To bypass our CDN you should change the GUID.

       

      Please note source code of Timeline is available on GitHub.

      Feel free to contribute to Timeline.

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]

      • Anonymous's avatar
        Anonymous
        Not applicable

        Has this issue been resolved? My visual is displaying incorrect year values, I have set up the Fiscal Year start month as October and Day as 1. The year value is not adjusting properly between 2018 and 2019. The fiscal year should reflect the value of 2019.