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 You can your Min Max calculation funtion (measure) under fx section.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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