Forum Discussion

NickzNickz's avatar
NickzNickz
Icon for Helper IV rankHelper IV
2 years ago

Range Maximum and Minimum Value by category

Hi ...   I have an issue with the Y-axis range for maximum and minimum. For now, I use the below measure to get the maximum value by category. However, I facing an issue when using it in a differe...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Since the scale of the entries in the Category column are different, i suggest that you insert a last Pivot column step to get the data in this shape.  Now write your measures

 

  • NickzNickz's avatar
    NickzNickz
    Icon for Helper IV rankHelper IV
    2 years ago

    Hi Ashish_Mathur ,

     

    This is the source file format ..

     

    Regards,

    NickzNickz

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    That is the formula you should be working with.  Just remove the Year and Month colums.

  • NickzNickz's avatar
    NickzNickz
    Icon for Helper IV rankHelper IV
    2 years ago

    Dear Ashish_Mathur ,

     

    I have my reason why I need my table to be like this ...

     

    Below is the result of the highest amount by category:


    If my chart1 only filters data for Purchase and Loan, the highest amount is 11,947.51. 
    If my chart2 only filters data for Rental and Profit, then the highest amount is 1,337,47.
    I need to use this value as an indicator when creating the measure and put it in the Y-axis range for maximum. I also need to create for Min range too. 

     

     

    Regards,

    NickzNickz



  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    Hi,

    Does this measure work?

    Measure = sum(Data[Amount])

    Measure 1 = MAXX(ALLSELECTED(Data[Category]),[Measure])

    Measure 2 = MINX(ALLSELECTED(Data[Category]),[Measure])