The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
User | Count |
---|---|
58 | |
56 | |
53 | |
49 | |
32 |
User | Count |
---|---|
172 | |
89 | |
70 | |
46 | |
45 |