Show values in chart from year start to the selected month value

[Ankit777]

Hi

I have monthly sales data.

I am creating a line chart.

I also use month as filter.

When I select a month, I want graph to show me data from Jan onwards to selected value.

Please help.

Thanks

[Eric_Zhang · Accepted solution]

---

@Ankit777 wrote:

Hi

I have monthly sales data.

I am creating a line chart.

I also use month as filter.

When I select a month, I want graph to show me data from Jan onwards to selected value.

Please help.

Thanks

---

@Ankit777

May I know why not using a date slicer to pick up a range?

As to your question, a trick is to create a calculated table containing duplicated rows.

Check more details in the attached pbix file.