Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello Friends,
I have a line chart which has four data points (ABCD). I'm using week as my axis. Now I'm at week 85. So, for week 86, I want only my data point C to be displayed along with the previous ABCD points.
Sorry for my painting skill 😛
@Anonymous ,Not very clear
if you have not selected a week in slicer, you can control the week in your measure
your need columns like
year Week = if('Date'[Week Number]<10,'Date'[Year]*10 & 'Date'[Week Number],'Date'[Year]&'Date'[Week Number])
OR
Week Rank = RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format
measure
Last 2 weeks =
var _max = Maxx(allselected('Date'), [Week Rank])
var _min =_max -2
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]>=_min && 'Date'[Week Rank]<=_max ))
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8
if you have selected the week
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
There is no issues with the week. I want to display only one data point for the upcoming weeks (i.e) C. I don't want to display the data points ABD.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.