Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ID | Tableau Planned Date | Submitted Date | test |
U-UST001-213-01 | 12/1/2020 | 1/8/2021 | 1 |
U-UST002-206-01 | 9/1/2021 | 1/8/2021 | 1 |
U-UST003-826-01 | 11/1/2020 | 1/7/2021 | 1 |
U-UAR201-781-01 | 12/1/2020 | 0 | |
U-UAU002-781-01 | 12/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?
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.
Hi @Anonymous ,
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
90 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |