Forum Discussion
Solved
Chart Filter Using a Variable?
Hello, I'm wondering for chart filter, is it possible to use a variable? Right now, I have to hard-code a number. Appreciated!
ok, now i understand. I was able to do this in excel 2013 with the old power query and powerpivot where by you fiddled with a piece of M code and could write back a variable from the spreadsheet into the datamodel. I will try and track it down but have had no luck so far. I bet you can still do it in powerbi given that its all the same - it will involve passing back value from an unrelated table. Sorry i dont have a solution at hand.
Its a measure to write. Go to modelling on the menu and then to new measure. If LAWRank is not a defined measure already it might need to be something like:
=calculate(sum[table[LAWrank],filter(table,table[measure]>5))
How is this dynamic?