Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 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
    9 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
Community Champion
9 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.

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      9 years ago

      Anonymous

       

      hi, you have 

       

      ValuesChart =
VAR MAXMONTH =
    VALUES ( Tabela1[Month] )
RETURN
    IF (
        VALUES ( DimensaoData[Month] ) <= MAXMONTH,
        ***YOUR COLUMN TO SHOW AS VALUE IN THE CHART***),
        BLANK ()
    )

       

      In the chart Use DimensaoData for Axis and Legend.

       

      Note: In you your DimensaoData the months are numeric. (1...12). If you don't have please add this column

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Vvelarde

         

        I can't get the chart. What is wrong?