Line Chart Axis Range based on maximum value of the 3years

[NickzNickz]

Hi... 

I have created a line chart. The line chart will display only the last 3 year data. For example,  2023, 2022, 2021, 2020, 2019, only 2022, 2021 and 2020 will be displayed. 

Below is the line chart I have created. 

A have several questions.

Question 1: 

How can I ensure the line chart Y-axis range will dynamically change/follow based on the latest maximum value within the 3years data?.. If the values for 2023 are more than the previous years (2022 and 2021), I don't need to change the axis range manually.

Question 2:
How can I ensure the Y-axis value remains unchanged when I click the category slicer?

Currently, when I click the category, the Y-axis value change according to the selection.

Line Chart Error Example:

Additional Input: 

This is the video I followed to create the chart: https://www.youtube.com/watch?v=8RzZppthNPk&t=323s 

 Regards,
NickzNickz

[Jihwan_Kim]

Hi, I am not sure how your datamodel looks like,  but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

[NickzNickz]

Hi @Jihwan_Kim ,

Have you been able to download the pbix file I included before. ...

If you need any clarification, please do not hesitate to contact me ...

Regards,

NickzNickz

[NickzNickz]

Hi @Jihwan_Kim 

Please find the attachment for your reference. If you are unable to access the file, please let me know ...

File: link 

Regards,

NickzNickz