Forum Discussion
Dynamic Date range on X axis for a Line Chart
I have a line chart that shows data for 2 projects (Line data is plotted cumulative over date). The projects can be selected using a slicer. Now the issue is one project is spanned over 4 monts (...
Hi naveenvs ,
Sorry, based on my test, I can't reproduce your situation. My sample data is this and the result is the displaying by the gif. I switch from project A to project B, and the month automatically ends in September.
SalesDateProject
| 4 | 8/8/2020 | A |
| 5 | 9/9/2020 | A |
| 6 | 10/10/2020 | A |
| 7 | 11/11/2020 | A |
| 2 | 8/8/2020 | B |
| 3 | 9/9/2020 | B |
| 1 | 8/1/2020 | A |
| 2 | 9/1/2020 | A |
| 3 | 10/1/2020 | A |
| 4 | 11/1/2020 | A |
| 5 | 8/1/2020 | B |
| 6 | 9/1/2020 | B |
The pbix file which I tested is here.
Could you provide some more detailed sample data? And I will try my best to help you.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.