Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Auto select previous months

Hi guys,   I want to know if it is possible select one month, and the others selected automatically, like a MTD (I suppose). I have an alternative, using quarters checkbox, but, what i really want ...
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    Anonymous

     

    Try this:

     

    Create a table with Months (1....12) Use this as Slicer. Don't related with your data table.

     

    Create a Measure: 

     

    ValuesChart =
VAR MAXMONTH =
    VALUES ( Months[Month] )
RETURN
    IF (
        VALUES ( Table1[Month] ) <= MAXMONTH,
        CALCULATE ( SUM ( Table1[Values] ) ),
        BLANK ()
    )

    Use this measure in your chart.

     

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
10 years ago

Anonymous

 

Try this:

 

Create a table with Months (1....12) Use this as Slicer. Don't related with your data table.

 

Create a Measure: 

 

ValuesChart =
VAR MAXMONTH =
    VALUES ( Months[Month] )
RETURN
    IF (
        VALUES ( Table1[Month] ) <= MAXMONTH,
        CALCULATE ( SUM ( Table1[Values] ) ),
        BLANK ()
    )

Use this measure in your chart.

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Vvelarde,

 

I tried your solution but I'm with some doubts.

 

I created a table with a Month column (1,2,3,4...,12)

 

 

Then I create a measure, but I've doubts what is the table/column that I need to put in "CALCULATE ( SUM...)"

 

ValuesChart =
VAR MAXMONTH =
    VALUES ( Dimensão Data[Month] )
RETURN
    IF (
        VALUES ( Tabela1[Month] ) <= MAXMONTH,
        CALCULATE ( SUM ( Tabela1[Month] ) ),
        BLANK ()
    )

I've already a Table with a date, year, month.. but I didn't related them.

 

 

I have my Month slicer from my Tabela1 data

 

What is the chart configuration?

 

 

Thanks in advance,

Flávio.