Timeline slicer Problems

Question

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. This table show begining ballance Monthly and I need the same but Weekly.

The formula for Saldo Inicial is :

Saldo Inicial = CALCULATE ( SUM('Indicadores Bancos'[Total_Bancos]),
FILTER(ALL('Indicadores Bancos'[Fecha].[Date]),DATEADD('Indicadores Bancos'[Fecha].[Date],1,MONTH) <= MAX ('Indicadores Bancos'[fecha].[Date])))

This formula is working Ok , but I try to do the same with the week an It doesn't work. Other question, what is beter work with the timeline visual or a HierarchySlicer about the week period.

Thanks

anonymous · Answer

Its likely to do with how each component is calculating what a Week is.&nbsp; So to make sure you are comparing Apples to Apples, check how you are getting the weeknumber in the matrix/table.&nbsp; Also check your timeline slicers options and see what you have set under "First Day of Week".&nbsp; Something as simple as having Sunday being the first day here, but Monday in the other one could change the outcome of what is classed as "Week 1".

miguelsaldana77 · Answer

This is the formula&nbsp;Semana-Año = CONCATENATE( CONCATENATE(YEAR('Indicadores Bancos'[Fecha].[Date]),"-"),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF(WEEKNUM('Indicadores Bancos'[Fecha].[Date])&lt;10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,CONCATENATE("0",WEEKNUM('Indicadores Bancos'[Fecha].[Date]))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,WEEKNUM('Indicadores Bancos'[Fecha].[Date])))&nbsp;I had to concatenate a cero when a week is lower than 10,&nbsp; in order to sort the weeks

anonymous · Answer

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 · Answer

&nbsp;Thanks for the formula, but I don´t understand finally the diference? Well, maybe is easier resolvel the result now?&nbsp;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?&nbsp;&nbsp;&nbsp;

anonymous · Answer

The main changes i made to your formula was simply removing redundant functions you didn't need.&nbsp; Think of it as a cleaned up version.&nbsp;I've attempted to replicate your scenario with the timeline slicer and i'm getting the same problem.&nbsp; It looks like the Timeline Slicer is calculating the week number differently to how Power BI does it.&nbsp; Its likely a fault within the custom visual itself.&nbsp;

Forum Discussion

Timeline slicer Problems

6 Replies

Related content

Timeline Slicer Usability

Problem with field parameter and empty slicer

Timeline slicer bugged since latest PowerBI update

Timeline Slicer issue

Logic problem?