Dynamic Date range on X axis for a Line Chart

[naveenvs]

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 (Aug - Nov) and other project is over 2 months (Aug - Sep). when I select the latter, I need to break the X axis (Date) when the project ends in Sep. Is there a way I can make the X axis dynamic based on the selction of the project.

[v-stephen-msft]

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.

[amitchandak]

@naveenvs , ideally when the project, which is having two months of data, it should two display months only. but difficult to say without looking at data and formula and screenshot.