Forum Discussion
thliberato
9 years agoHelper I
Dynamic Graph month
I have a calendar filter to choose a month. I have a bar Graph with quantity tickets x System Name X Month. I need show in this graph the last 12 months considering the month selected in filter. ...
austinsense
9 years agoImpactful Individual
https://msdn.microsoft.com/en-us/library/ee634539.aspx
=CALCULATE( [whatever_measure_you're_using],
DATESINPERIOD(Calendar(Date], MAX(Calendard[Date]), -12, MONTH)
)- thliberato9 years agoHelper I
austinsense, Good Morning.
It did not work out as I expected.
This is the Example.
I Have a Filter Data to choose one month. When I choose the month, my Graph needs show me only last 12 month, including the month selected.Once again, thank you.
- austinsense9 years agoImpactful Individual
Sorry this is my fault - I answered the wrong question :/
You're looking for a dynamic filter on the date axis - I have to get to a meeting but I can take a look at this later.
- thliberato9 years agoHelper I