Forum Discussion
Min and Max Values in Chart Graph per month
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
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.
8 Replies
Tahreem24Super User
Anonymous Follow as per the below Screen shot and likewise add 2 lines as per you need.
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.