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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
cocomy
Resolver I
Resolver I

Graph type - Categorial

Hi All,

 

When I chose categorial type under line graph, scroll button appears in the bottom.

 

How can I get rid of it as I want to see all range all at once.

 

For example, I want to squeeze 1 Jan 2017 till 1 Dec 2017 (in Width 900 , Height 600) without scrooling .

 

Appreciate your help!

 

All the best,

cocomy

 

 

5 REPLIES 5
rocky09
Solution Sage
Solution Sage

one way is to change the font size of X axis and other way could be formatting Date as mm/dd/yy. Just an idea.

rocky 09,

 

Thank you very much for your advice. I tried your recommendation.

 

I still have to scroll to see all at once.  Appreciate if you can come up with another idea!

 

All the best,

cocomy

Can you post a screenshot?

Hi Rocky 09

 

Here is an exapmple. I would like to show Jan 2017 - Dec 2018 without scrolling.

 

Is it possible to squeeze ?

 

I like to use line with marker, I need to select categorial in this case.

 

All the best,

cocomy

 

 

2018_03_05_tky_temp.PNG

 

 

@cocomy

You are trying to see all (365 days) in that graph. I don't think, you can see day by day data without a scroller.

 

Work around 1: Just Put Date on X-axis (Without Date Hirarchy) and then go to format then Change the X-axis  Type to Continuous.

Work around 2: You can use Drill Option with Date Hirarchy, So, you can drill down the data without a scroller.

 

 

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.