cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Naveen_SV
Helper III
Helper III

Help on Burn Down Chart Design

Hi All,

 

I am creating a brun down chart, Can anyone please help me i have stuck with complition number is not coming properly.

 

Below is my Table,

 

In the same table i was able to write below query.

 

Rank = RANKX('dummy data - Copy','dummy data - Copy'[Warrenty Date],,ASC,Dense)
 and the running table
 
Running_table = CALCULATE(SUM('dummy data - Copy'[Count_of_CAR_Asset]),
ALLEXCEPT('dummy data - Copy','dummy data - Copy'[Country]),'dummy data - Copy','dummy data - Copy'[Rank] <=EARLIER('dummy data - Copy'[Rank]))
Remaining scope as below
 
Remaining scope = CALCULATE(SUM('dummy data - Copy'[Count_of_CAR_Asset]),FILTER('dummy data - Copy','dummy data - Copy'[Country]=EARLIER('dummy data - Copy'[Country])))-'dummy data - Copy'[Running_table] + 'dummy data - Copy'[Count_of_CAR_Asset]
I am seeing the burn down chart numbers wrong ideally it should start from 2213 and next month should lesser then pervious month that means pervious month total - next month total and reduces to zero at the end of the month.
 
Please let me know any soluton to solve this issue.  
 
burndown3.PNG
 

 

 

burndown1.PNGburndown2.PNG

1 ACCEPTED SOLUTION
Naveen_SV
Helper III
Helper III

@v-angzheng-msft  really thanks for replying to my problem.

 

I was actually looking based on filters when you apply like from your data, if i select Amestradom remaining count should show 911 for the month of jan and it should dedect next month total. 

 

even if i select asset like "laptop", Mobile based on that group also should be able to see from total - previous month total.

currently i was able to get the solution by saperating two graph one is based on country and another based on mobile.

View solution in original post

2 REPLIES 2
Naveen_SV
Helper III
Helper III

@v-angzheng-msft  really thanks for replying to my problem.

 

I was actually looking based on filters when you apply like from your data, if i select Amestradom remaining count should show 911 for the month of jan and it should dedect next month total. 

 

even if i select asset like "laptop", Mobile based on that group also should be able to see from total - previous month total.

currently i was able to get the solution by saperating two graph one is based on country and another based on mobile.

v-angzheng-msft
Community Support
Community Support

Hi, @Naveen_SV 

 

Check if the summation method of the value field is summation. The displayed result is incorrect if the summation method is summation because there are duplicate remaining values when the consumption is 0. Change the aggregation method to average, maximum, minimum, etc.
I created a sample based on the image you provided and in the sample I created two measures as follows:

_Running =
VAR _running =
    CALCULATE (
        SUM ( 'Table'[Count of CAR Asset] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[__Rank] <= MAX ( 'Table'[__Rank] ) )
    )
RETURN
    _running
__Remaining =
VAR _total =
    CALCULATE ( SUM ( 'Table'[Count of CAR Asset] ), ALL ( 'Table' ) )
VAR _result = _total - [_Running]
RETURN
    _result

 Result:

vangzhengmsft_0-1628487048689.pngvangzhengmsft_1-1628487060644.png

Please refer to the attachment below for details

 

 

Hope this helps.

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!