Forum Discussion
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.
Sorry for my painting skill 😛
2 Replies
- amitchandak
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 formatmeasure
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=pnAesWxYgJ8if you have selected the week
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
