Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
Hi all()Given the following table and Line Chart and considering:- Sprint ends on May,25th
BurnUp ChartI want both table and line chart to show the Daily Pace till the end of the sprint.These are the measures related do Daily Pace I have so far:
And I have the Sprint End Date as a column in my Table data.
How do I do this?
Go to Solution.
Hi @aramirez7 Thanks a lot for answering. I´m kind of lost on how to effectively operate your solution.The 'Source' would be the calendar table or a metric? Or should it be written in the Power Query Editor?
Well, I already got a way to make the chart display all days using a measure combined with the ALLSELECTED statement.Thank you very much!
View solution in original post
1. Create a calendar table with the number of future days you want, see this ejm with 15 future days
letSource = #date(Date.Year( DateTime.LocalNow())-1,1,1),allDates = List.Dates(Source, Number.From(DateTime.LocalNow())+15 - Number.From(Source) ,#duration(1,0,0,0))
2. Change the TOTALYTD function to something like:
Annual cumulative =VAR startDate = DATE(YEAR(TODAY()),1,1)VAR endDate = MAX( Dates[Date])Return, NewCALCULATE,[Puntos planed daily],FILTER( ALL( Dates ),DATESBETWEEN(calendar_dim[dateKey],startDate, endDate))
I'd think that might work for you, greetings.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.