Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
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.
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.
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!
If my post helped you so please accept this as a solution so that it will be helpful for others members.
Thanks!
@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?
Screen shot is not very easy with this, but could the problem be that I am using a table visualisation as opposed to a calculated table?
Does this need to be a calculated table?
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |