cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Dynamic Burndown/Rundown DAX

Hi All,

 

I am trying to build a dynamic (able to filter by other data in the sheet) burndown chart with a "Plan" line and an "Actual" line. Here is a sample of my data:

Systemization - Subsystem IDTableau Planned DateSubmitted Datetest
U-UST001-213-0112/1/20201/8/20211
U-UST002-206-019/1/20211/8/20211
U-UST003-826-0111/1/20201/7/20211
U-UAR201-781-0112/1/2020 0
U-UAU002-781-0112/1/2020 0

 

Here is my measure for the "Plan" line - which seems to work just fine.

 

Baseline Profile = 
CALCULATE (
    COUNT ( 'Tableau MC Skyline'[Systemization - Subsystem ID] ),
    FILTER (
        ALLSELECTED ('MC Skyline'),
        'GCGV Tableau MC Skyline'[Tableau Planned Date] >= MAX ( 'Tableau MC Skyline'[Tableau Planned Date] )
    )
)

 

As you can see, the baseline starts properly, but my actual line does not start from the same point, because i am using my test values. Below is a sample of my current chart as well as my DAX for the actual line. How do i get the actual to start at the top near baseline and have the delta at the bottom? Also, is there a way to make the actual line visually stop at today's date?

Capture.PNG

 

 

 

 

 

 

 

 

Actual = 
CALCULATE(
    SUM('Tableau MC Skyline'[test]),
    FILTER(
        ALLSELECTED('Tableau MC Skyline'),
        'Tableau MC Skyline'[Tableau Planned Date] >= MAX ('Tableau MC Skyline'[Tableau Planned Date])
    )

 

 

Any help is appreciated.

1 REPLY 1
Community Support
Community Support

Hi @Kiewit ,

 

To stop at today's date,you could modify your  "filter" part as below:

FILTER(
        ALLSELECTED('Tableau MC Skyline'),
        'Tableau MC Skyline'[Tableau Planned Date] >= MAX ('Tableau MC Skyline'[Tableau Planned Date])&&'Tableau MC Skyline'[Tableau Planned Date]<=TODAY()
    )

The start point of the actual line depends on the data it gets,if possible,could you provide some sample data for test?

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors