Forum Discussion
Burndown chart with parameters
Hi all, I want to know if it is possible to build a interactive burndown chart with parameters selected by user? I have two parameters, quantity of "Tools" that we want to review and the quanti...
Hi Krlos5411 ,
Based on your description, you want to calculate the number of weeks needed to achieve the goal based on the parameters and then reflect it on the x-axis, right?
You can create a Flag measure then place it on the visual object and set [Flag=1].
Flag =
var _select1=SELECTEDVALUE(tools[tools])
var _select2=SELECTEDVALUE('weekly total'[weekly total])
var _value=DIVIDE(_select1,_select2)
RETURN IF(MAX('Table'[Week])<=_value,1,0)
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Neeko,
What will it be the table/value for 'Table'[week]?
Also, how should I arrange the parameters in the graph? I'm trying to input the 'Tools' in the Y axis and your Flag field in the X but it doesn't work