Forum Discussion

chickenlicken's avatar
chickenlicken
Icon for Helper I rankHelper I
6 years ago
Solved

Returning the maximum value from a table (or ideally, a box/whisker plot) to display in a card

Hello!

I've been researching this question but struggling a little - I think that it may relate to Power Query which I have not yet ventured into, so would appreciate some pointers / help.

 

I have a table and charts that update based on filters applied by the user.

 

I would like to display a card next to the table that shows the maximum and minium values from those charts/table, that updates as the user changes the filter. 

 

I would also like to be able to use these changing values in a formula to produce a score, which will also be displayed in the card.

 

What is the best method?

 

Thanks!

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi chickenlicken ,

     

    If i understand you correctly, you can use Measures to achieve your purpose.

    Here's some sample data and measures

    max = MAX('Table'[Amount])
min = MIN('Table'[Amount])
score = [max]/[min]

    The values of max or min will be changed by slicers or page level filters and the value of formula which is using these changing values will also be changed.

    For more details please check the documents below.

    https://docs.microsoft.com/en-us/power-bi/desktop-measures.

    https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures.

    BTW, if you want one of the visual to be unaffected,

    for slicers, please inactive the interactions:

    for filters, please use visual level filters.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

6 Replies

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    chickenlicken ,

     

    Create Measure for Min and Max like below and use them into Card visuals: (Screen shot is attached)

                Max = Max(Table[Value])

                Min = Mix(Table[Value])

     

     

    Don't forgrt to hit THUMBS UP and Accept this as a solution if it helps you!

    • Tahreem24's avatar
      Tahreem24
      Icon for Super User rankSuper User
      6 years ago

      chickenlicken ,

       

      If my post helped you so please accept this as a solution so that it will be helpful for others members.

       

      Thanks!

      • chickenlicken's avatar
        chickenlicken
        Icon for Helper I rankHelper I
        6 years ago

        Tahreem24  Thank you - your solution looks very simple but when I try to create a new measure I get an error-  it doesn't recognise "Table"...  do I need to rename the table somehow? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi chickenlicken ,

     

    If i understand you correctly, you can use Measures to achieve your purpose.

    Here's some sample data and measures

    max = MAX('Table'[Amount])
min = MIN('Table'[Amount])
score = [max]/[min]

    The values of max or min will be changed by slicers or page level filters and the value of formula which is using these changing values will also be changed.

    For more details please check the documents below.

    https://docs.microsoft.com/en-us/power-bi/desktop-measures.

    https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures.

    BTW, if you want one of the visual to be unaffected,

    for slicers, please inactive the interactions:

    for filters, please use visual level filters.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.