Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

Displaying different data point in line charts

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.

 

AA00_0-1638253766607.png

Sorry for my painting skill 😛 

2 REPLIES 2
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

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.

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.