Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I have multiple paramterers I want people to be able to change which act as weigthings for a series of measures, but never add to more than 1.
I want to make something along the lines of:
param1=GENERATESERIES(0, 1, .05)
param2=GENERATESERIES(0, (1-SELECTEDVALUE(param1), .05)
param3=GENERATESERIES(0, (1-SELECTEDVALUE(param1)-SELECTEDVALUE(param2), .05)
...
I didnt think it would be as hard as it is. Any ideas on how to do this?
Cheers,
Sam
Solved! Go to Solution.
Correct. Is there a way to do that?
Can you try to explain a bit more what you need? I don't quite get it. An example based on your data would be useful.
The first parameter is made with GENERATESERIES(0, 1, .05)
The second and subsequent need to be made with the EndValue being 1-sum of the selected values of the previous generated series.
Hi @samdthompson ,
I think you want to create parameters by previous value automitically. Is it right?
Correct. Is there a way to do that?
Hi @samdthompson ,
There isn't a way to do it currently in Power BI. However, you can post your idea here to make it a feature of Power BI in the future.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |