Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Keep Min and Max on graph while changing selection

Hi,   I have a form with multiples questions and notes from 0 to 10 for each questions. I made a graph with the min and max for each questions :   The interviews have been made for several...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try

    Min_Brand = CALCULATE(MINX(results,results[Moyenne]),ALL(results[Brand]))

     

    Please note as you have other measures in graph, which will still filter and keep on moving question position. You might see min moving. The best way to test is only to have this measure on the graph.

     

    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
    Thanks.

    My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

     

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Try

Min_Brand = CALCULATE(MINX(results,results[Moyenne]),ALL(results[Brand]))

 

Please note as you have other measures in graph, which will still filter and keep on moving question position. You might see min moving. The best way to test is only to have this measure on the graph.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Amit. Works great ! 👍