Forum Discussion

MiguelSaldana77's avatar
MiguelSaldana77
Resolver I
9 years ago

Timeline slicer Problems

I have Problems with the Visual "Timeline"  when I select a specific week, this display the next week. This is the first problem, but I need to show in a table something like the next image.  ...
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Ok i've cleaned up your formula, this should do the exact same thing as your longer one:

Semana-Año = YEAR('Indicadores Bancos'[Fecha].[Date]) & "-" & FORMAT(WEEKNUM('Indicadores Bancos'[Fecha].[Date], 1), "00")

I've explicitly stated to start your WEEKNUM calculation where the Week begins on Sunday.  if you change the ", 1" to a ", 2" in the WEEKNUM formula, you can change this to Monday if you like.

 

Now just check your setting for your Timeline Slicer, click on it and check in the Format section (looks like a paint roller).  There is a section called "First Day of the Week"

MiguelSaldana77's avatar
MiguelSaldana77
Resolver I
9 years ago

 

Thanks for the formula, but I don´t understand finally the diference? Well, maybe is easier resolvel the result now?

 

And I understood from the first time your sugeestion about the option, this is the default format and I don't see other opción to change. Any idea?

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    The main changes i made to your formula was simply removing redundant functions you didn't need.  Think of it as a cleaned up version.

     

    I've attempted to replicate your scenario with the timeline slicer and i'm getting the same problem.  It looks like the Timeline Slicer is calculating the week number differently to how Power BI does it.  Its likely a fault within the custom visual itself.