Forum Discussion
Auto select previous months
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.
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.
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