How to make my chart still can display well when i don't select Year=2021 ?

[admin11]

Hi All

Below screen shot shown the chart display well when i select year =2021.

When i don't select Year =2021 , the chart dont display well.

My PBI file :-

https://www.dropbox.com/s/48xg9x4j592yrl9/PBT_V2021_365%20How%20to%20make%20target%20chart%20can%20d...

Paul

[pranit828 · Accepted solution]

Hi @admin11 

When you don't select the year, then all the years are selected by default.

What this means is that your data is now presented for 21 years and 12 months and 3 months from 2021 as per your chart. This is the reason why you see the scroll bar at the bottom.

Slide it to the right and you will see the 2021 year 3 months displayed and the red "target YTD" line.

[admin11]

@pranit828 

You are very sharp.

Thank you for spot that. it help me.

Paul

[aj1973]

Hi Paul,

A work arround could be to turn on the Single select of that Year slicer 

[admin11]

@aj1973 

Thank you for sharing 

may be due to my question not clear 

what I want to remove initial select button for thid Tab

meaning user don't need to click on Year = 2021 in order to see the chart.

[aj1973]

That's why you need to turn on single select of the slicer on year 2021...have you tried it!