Forum Discussion
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 brands. I would like to keep the min and max on the graph while I change the selected brand.
Any IDEA ?
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
5 Replies
Anonymous how does your data looks like? What measure you are using for min and max? Basicall in your measure you need to ignore Band filter which can be achieved by using ALL function.
Not sure I got but, All, all except are few option to explore
QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),all(brand),DATESMTD(dateadd('Date'[Date],-1,QUARTER)))
In above brand filter will be ignored
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/823601Hi,
Thank you for you answers. Here are the PBIX and the Excel file I have been working on to be more precise.
As you can see, when I select a brand, the min and max disappear.
I have tried the ALL function but it does not seem to work with MINX :
Min_Brand = CALCULATE(MINX(results;results[Moyenne];ALL(results[Brand])))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
