Forum Discussion

Krlos5411's avatar
Krlos5411
Frequent Visitor
1 year ago

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 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??

 



Need Help
Tips and Tricks
Tutorial Requests

5 Replies

  • Rupak_bi's avatar
    Rupak_bi
    Icon for Super User rankSuper User
    1 year ago

    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's avatar
      Krlos5411
      Frequent Visitor
      1 year ago

      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's avatar
        Rupak_bi
        Icon for Super User rankSuper User
        1 year ago

        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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      Krlos5411
      Frequent Visitor
      1 year ago

      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