Burndown chart with parameters

[Krlos5411]

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 quantity of tools that we want to review weekly.

E.g.: If the parameter for Tools goal is 50 and the parameter Weekly Tools is 5 I have a measure that divides the total amount of tools (50) in the total amount of weekly tools (5) to have the amount of weeks needed to achieve the goal (10)

So what I whant is to have this interactive values imputed in the burndown chart and the measure to moves in the quantity of week in the X axis.

Do you thinks this is possible??

[Anonymous]

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. 

[Krlos5411]

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

[Rupak_bi]

Hi @Krlos5411 ,

You already have two parameters for total tool and weekly tool. Make another numeric parameter as week numbers to plot X axis. Then follow below image to achive this dynamic plotting.

[Krlos5411]

Thanks!

Can you help me polishing my formula?

Total should be 50 as that is the toal set in the parameter, not 225.

The total should be 50 as is set in the parameter, then the weekly tools as 5, determine that the 50 tools with 5 tools by week, should require 10 weeks to do it (variable x axis). 

And the both last values are 0.

Also, how can I add a new value as the actual development? The measure is an actual count of tools. I just drag it to it?

[Rupak_bi]

Hi @Krlos5411 ,

225 cannot come. Something you are missing. Try to diagnose step by step. 

1. Check output of the total tool and weekly tool individually by modifying the MAXX expression. I am sure you will get the bug.

2. To add actuals, make sure, the table consisting actual data, must have a week no column. Make a relationship between the week table to the fact table on week nos. Then you can drag the actual column or measure.

If stucked, share pbix or sample data of fact table.