Forum Discussion

PMPalex's avatar
PMPalex
Frequent Visitor
7 years ago
Solved

VARIABLE: UNDESIRED BEHAVIOR

Hi,    I have a line chart where I want it to show the data only until the selected month. This is the metric that I created with a variable that returns that month's number.   The result of the ...
  • AlB's avatar
    AlB
    7 years ago

    PMPalex

    See the attached file for an example. Like I said, this is a quick and dirty solution. You should eschew the auto date/time feature altogether and create your own date table that can be used in the slicer The auto date/time feature can be turned off at

    Options and settings->Options->  Current File -> Data Load ->Time Intelligence

    and at 

    Options and settings->Options->  Global -> Data Load ->Time Intelligence

     

    Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.

    Cheers  Datanaut

PMPalex's avatar
PMPalex
Frequent Visitor
7 years ago

I created the new column called "MES" and this metric but it doesn't work....  it is right? THANKS!

 

 

SeleccionMeses =

VAR MesSeleccionado=SELECTEDVALUE(Hoja1[MES])

RETURN

CALCULATE (SUM(Hoja1[IMPORTO_FST])*2;
ALL (Hoja1[DATE_REF].[NroMes]);
Hoja1[DATE_REF].[NroMes] <= MAX(MesSeleccionado;blank())
)
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

PMPalex

See the attached file for an example. Like I said, this is a quick and dirty solution. You should eschew the auto date/time feature altogether and create your own date table that can be used in the slicer The auto date/time feature can be turned off at

Options and settings->Options->  Current File -> Data Load ->Time Intelligence

and at 

Options and settings->Options->  Global -> Data Load ->Time Intelligence

 

Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.

Cheers  Datanaut