Min and Max Values in Chart Graph per month

[Anonymous]

Hello, 

im sorta new to Power-BI and I´d like to ask for assitance regarding a problem i ran into. I have a column chart thats part of my Dashboard, which displays the average customer Feedback (range 1-5) on a monthly scale (as shown in the picture). I would like to add a marker that indicates the minimum an maximum Feedback rating that occured within every given month (similar to the screenshot below). Is there any possible measure/function or setting capable of that?

Thanks a lot!

-Niklas

[Tahreem24]

@Anonymous  Follow as per the below Screen shot and likewise add 2 lines as per you need.

[Anonymous]

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:

[Tahreem24]

@Anonymous You can your Min Max calculation funtion (measure) under fx section.

[Anonymous]

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 · Accepted solution]

@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.

[Anonymous]

Thanks a lot my G!

Im going to give it a try in a bit. 🙂 

[peffany]

I know its been a while but did you end up finding the solution to this problem? I'm currently trying to do the same thing as you.

[Anonymous]

Hi, I'd also be interested to know if anybody has found  solution to the above? Thanks