Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 (ran...
Need Help
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    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.

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

Thanks a lot my G!

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

  • peffany's avatar
    peffany
    Frequent Visitor
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

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