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.
Dear Comunity,
I created What If parameter, but after 2 weeks of production usage there is a need to change its incrementation,
now it increments by 100 but need to change step to 1 ....but...
I can't see edit parameter option anywhere to be honest, can't find it
Solved! Go to Solution.
@BarSi1986 , That is because what if parameter sampling.
Better you create your own table using series using generateseries(1,5000,1) and use that
I'm not sure if you can get back to the GUI but if you click on the parameter table it creates:
You can then edit the table definition in the expression bar:
Syntax is GENERATESERIES(Start, End, Increment)
@BarSi1986
you can do that , Just go to column generated from the Whatif window and you will see the GenerateSeries Function
in that change the increment (final parameter) to what ever value you want!
Proud to be a Super User!
ok, it works.....almost 🙂
now if i type, for example 1592 --> it automatically changes to 1590 (incrementation is now by 1...)
so the DAX looks like that:
param value = GENERATESERIES(0, 5000, 1)
@BarSi1986 , it should have created a table using generateseries. Go and modify that and try
ok, it works.....almost 🙂
now if i type, for example 1592 --> it automatically changes to 1590 (incrementation is now by 1...)
so the DAX looks like that:
param value = GENERATESERIES(0, 5000, 1)
@BarSi1986 , That is because what if parameter sampling.
Better you create your own table using series using generateseries(1,5000,1) and use that
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 |
---|---|
112 | |
97 | |
83 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |