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.

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

anyone?!

tnolan's avatar
tnolan
Frequent Visitor
9 years ago

I dont know of a way to dynamically default slicers. I am sure this is a feature that is coming. You can statically default slicers by selecting the months you want then saving. When you or someone else views the report, then those months that were highlighted when you saved will be the default selection on the filters.