Forum Discussion
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 ...
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
Community Champion
Community Championwhat is the message in ver Detalhes
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 thank you,
It is possible replicate your code in a card label, to show me a % ?
I'm using your code unsuccessful in my card label:
Var = VAR MAXMONTH = VALUES ( 'Calendar'[MonthNumber] ) RETURN IF ( VALUES ( 'Calendar'[MonthNumber]) <= MAXMONTH; CALCULATE ( DIVIDE('OINV E ORIN'[Variação Current vs Previous Year tons Activos];'OINV E ORIN'[Consumo de clientes Tons Previous Year];0) ); BLANK () )- Vvelarde
Anonymous
The measure fail becasuse There is not a unique Calendar's Month selected, in the chart this work because your Axis is the each month so Values is a unique row.
What is the % that you want to show