Forum Discussion
Plotting data till current period in a line chart graph when plotting for several years
Hi I'm plotting a graph which shows results for the last 6 years (with the delay in quarters from the start of each year displayed on the x axis). Currently I see, even for the more recent years, d...
Hi again amitchandak. Kindly see graphs below. I would like to display for e.g. year 2021 only data points till the quarters that have elapsed from start of that year, i.e. upto quarter 3. Similarly for 2020 only till quarter 7, 2019 till quarter 11...year 2016 till quarter 23. In excel we can simply remove specific data points, how can we do the same in power bi?
Does this clarify the question or do you want me to send table info as well?
Regards
Raj
Hi Anonymous ,
It depends on what your underlying data looks like. You have 0-23 on the x-axis, is that mean you have data corresponding to 0-23 for each year in the table?
Best Regards,
Jay