Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Suppose we have a table of rows that have a column we'll call X. We want to add a calculated field to the model for that table which would have a value of f(x), where the function does something like multiply the value of X by a user-defined value which I'll call N. We want to allow the user to change the value of N on the dashboard using a slider, so they can manipulate the value of f(x).
I'm thinking we need to define a free-standing variable (not a column in the rows of the data model) for N, which is acts like a context variable. We can then reference that variable in DAX to compute f(x), and we can point a slider to N, allowing the user to increase or decrease its value.
How do we create that variable, so it can be referenced in DAX and by the slider?
hi @Anonymous
Try to
1)create a calculated table like:
Parameter =
SELECTCOLUMNS(
GENERATESERIES(1, 10, 1)
"N", [Value]
)
2)plot a slicer with Paremeter[N] column
3)use SELECTEDVALUE(Paremeter[N]) in your code to capture the value.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |