Forum Discussion

tlh's avatar
tlh
Frequent Visitor
5 years ago

Two lines, one chart

I'd pull my hair out if I had any left.....   I'm trying to have two lines on one chart. One line is expected burndown. The other is actual burndown. This is to display how we've used our budget ov...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, tlh 

I am not sure if I understood your question correctly, but when putting the budget into the visualization, please try to create the measure like below in order to allocate amounts correctly per day.

Please check the below picture and the sample pbix file's link down below. It shows the measure that is for creating the allocation measure to know day-by-day-budget amount. Then, the granularity will be the same as the actual expense table, and those two data can be put into the same visualization.

 

 

Budget Total =
SUM(Budget[Amount])
 
Budget Total Daily Allocation =
VAR dayscount =
CALCULATE (
COUNTROWS ( Dates ),
FILTER ( ALL ( Dates ), Dates[Year] = MAX ( Dates[Year] ) )
) - 1
VAR dailyamount = [Budget Total] / dayscount
VAR dailycumulate =
SUMX (
FILTER ( ALLSELECTED ( Dates ), Dates[Date] <= MAX ( Dates[Date] ) ),
[Budget Total] / dayscount
) - dailyamount
RETURN
[Budget Total] - dailycumulate
 
 
 

Hi, My name is Jihwan Kim.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

tlh's avatar
tlh
Frequent Visitor
5 years ago

Hi Jihwan,

Thanks for sharing this. How was the date table created? I can't see the formulas. 

TLH

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, tlh 

    Thanks for the feedback.

    I usually create dim-date table in Power Query Editor.

    You can go into the Power Query Editor and can see the table. It is not imported but it was directly created inside the power query editor.

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM