Forum Discussion

enzo18's avatar
enzo18
Frequent Visitor
7 years ago

Timeline slicer - ISO week

Hi, is there any possibility how to set ISO week date system in Timeline slicer? For example 2018-12-31 should be W1 (first day of week is Monday). Thank you, Vaclav
timeline
v-viig's avatar
v-viig
Community Champion
7 years ago

Hi,

 

Have you tried using Fiscal Year Start and Fiscal Day of Week?

 

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

[email protected]

enzo18's avatar
enzo18
Frequent Visitor
7 years ago

Hi,

Yes, I did. When you set Fiscal Year Start to 31st December you will get 1st week but year will be 2018 instead of 2019. The second problem is that next year will start on 30th December.

Thank you for your help.

 

  • v-viig's avatar
    v-viig
    Community Champion
    7 years ago

    Thanks for checking it.

     

    We'll add such a feature into our backlog to implement it in upcoming sprints.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi V-viig, 

      I am facing the same issue and I was wondering if you have now implemented this new feature or not yet ? is there a workaround ?

       

      thanks a lot for your help, AnneSo

      • akaefer's avatar
        akaefer
        Advocate I
        5 years ago

        Hi AnneSo,

         

        my workaround was in "Format" - "Fiscal Year Start" to set Month to "January" and Day to "4".

        But this willl only work for 2020/2021, of course!

        In my case not a big problem as my users are only interested in last 12 weeks' data.

        Hopefully the Custom Visual is being updated otherwise I have to again modify this setting until end of 2021!

        😞

         

        Best regards

        Armin