Shows each 5 year in line chart

[HaiVN]

Hello,

I have data with to columns: average income and year  for 20 years from 2000  to 2020.
I can make a line chart to show average income( y axis) and year ( X axis) for 20 years
My problem is I want to change graph to show data at each 5 year: 2000, 2005, 2010,2015,2020.
I plan to add one kolumn which show "Yes" for year =2000, 2005, 2010,2015,2020. and "No" for other and use this for filter! Do you have any other better ideas? 

Thank you! 

[v-kaiyue-msft · Accepted solution]

Hi @HaiVN ,

You can create a measure.

FilteredYears =
IF(
SELECTEDVALUE('Table'[Year]) IN {2000, 2005, 2010, 2015, 2020},
1,
0
)

Then drag it into the filter pane on the right to filter the data with a value of 1.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[Ashish_Mathur · Accepted solution]

Hi,

Expand the filter pane and select your desired years there.

[v-kaiyue-msft · Accepted solution]

Hi @HaiVN ,

You can create a measure.

FilteredYears =
IF(
SELECTEDVALUE('Table'[Year]) IN {2000, 2005, 2010, 2015, 2020},
1,
0
)

Then drag it into the filter pane on the right to filter the data with a value of 1.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[WulffJoergen]

The alternative to that is to create a temporary table that starts filtering on those years. In that way you will not create a new column. But then again if your PBIX file is not heavy, your solution works fine.