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

 

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?

 

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    what is the message in ver Detalhes

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      MdxScript(Model) (6, 46) miscalculation as 'OINV AND ORION' [Values Chart] was provided a table of various values where it was expected one value

      • Vvelarde's avatar
        Vvelarde
        Community Champion
        9 years ago

        Anonymous

         

        I made a sample of this.

         

        Sample