Forum Discussion
Min and Max Values in Chart Graph per month
Anonymous As I am not aware of your dataset. I assume that must be a Date Column and based on it we will calculate the MIN value month wise.
MIN MEASURE = CALCULATE(MIN(TblName[NumericColumn]),ALLEXCEPT(TblName,MONTH(TblName[DateColumn])))
Likewise, create for MAX value month wise.
Hi, thanks for the quick response!
that would take care of getting a max/min value overall, but i would need the max/min for every individual month. Here is another screenshot:
I´d need to get the minimum and maximum value for every occuring month on its own.
if i use a constant line with a min/max function it´ll end up looking like this:
Super UserAnonymous You can your Min Max calculation funtion (measure) under fx section.
Hi, thanks again! 🙂
Thats what i did in the screenshot of my reply above. Unfortunately that´ll only give me a constant min-value across all months. I would need a function/measure that tracks the min-value for every single month of my dataset.
- Tahreem24
Anonymous As I am not aware of your dataset. I assume that must be a Date Column and based on it we will calculate the MIN value month wise.
MIN MEASURE = CALCULATE(MIN(TblName[NumericColumn]),ALLEXCEPT(TblName,MONTH(TblName[DateColumn])))
Likewise, create for MAX value month wise.
Thanks a lot my G!
Im going to give it a try in a bit. 🙂