Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
admin11
Memorable Member
Memorable Member

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

Hi All

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

admin11_0-1615676103080.png

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

admin11_1-1615676182366.png

My PBI file :-

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

 

Paul

1 ACCEPTED SOLUTION
pranit828
Community Champion
Community Champion

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.





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

View solution in original post

5 REPLIES 5
pranit828
Community Champion
Community Champion

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.





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

@pranit828 

You are very sharp.

Thank you for spot that. it help me.

Paul

 

aj1973
Community Champion
Community Champion

Hi Paul,

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

aj1973_0-1615681087581.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

@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
Community Champion
Community Champion

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

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.