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, get a free DP-600 exam voucher to use by the end of 2024. Register 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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