How do I hide the last 90 days of the line on the chart below? The line represents the 365 day rolling average win % calculation.
Win % measure:
Win% for All Jobs during Period Selected :=
[Total Jobs Won],
[Total Jobs during the selected period],
Rolling 365 day average for Win % measure:
Win% Rolling 365 Days Avg :=
[Win% for All Jobs during Period Selected],
LASTDATE( Dates[Date] ),
The line on the graph below represents the 365 day rolling average. How do I adjust the measure above to hide the last 90 days of the line?
Go to Solution.
Hi @JRHans09 ,
In your scenario, you can add the IF() function to change the value of the last 90 days to blank(), then it will not display.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.