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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ravishankar2612
Regular Visitor

How to build a line chart without aggregating in Y axis

Hi ,

 

I am trying to create a line chart . with date in x axis and values in Y axis . If i pull the values in to Y axis field column i couldnt have the chart without any agg function like (sum,min..)

As a work around i changed the date column in to text and tried . Its working now but since i have more than5L rows the chart is with scroll bar down as its very big . how i can fit to page by changing the intervals in X axis 

 

Any help from both the methods will be helpful 

 

Thanks

Ravishankar N R

4 REPLIES 4
Ravishankar2612
Regular Visitor

Can anyone please let me know if any additional information required to do the analysis 

rajendraongole1
Community Champion
Community Champion

Hi @Ravishankar2612 -Fitting it to the page with an appropriate interval in the X-axis requires a few adjustments in Power BI.

 

on X-axis- change from continous to categories to show all the X-axis label and also minimum category width adjustment to max. 

 

if you have many on your X-axis you can create hierarchy like Dates to drill down.

also changing the xaxis from continous to categories will give you less data points.

reducing font size also we can add more categories and try to reduce the scrollbar horizontally. 

 

 

rajendraongole1_0-1718282969444.png

 

Try the above options and let know.

 

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Hi Thanks for the reply , For some reason i couldn't find the Layout under X axis and Minimum category width.

 

if you have many on your X-axis you can create hierarchy like Dates to drill down.

No I need to show all the X-axis dates in one chart

 

also changing the xaxis from continous to categories will give you less data points.

If we change Xaxis date to continous , the Y axis will not be a raw data we need to select a agg function , I dont need this to happen

 

reducing font size also we can add more categories and try to reduce the scrollbar horizontally. 

I have 30L rows , so was trying to figure out a way like we do in excel by selecting minimum and maximum date values with some intervals so that all the dates will be visible and also the Y axis will be a raw data without any agg function

 

Thanks 

Ravishankar

Hi Thanks for the reply , For some reason i couldn't find the Layout under X axis and Minimum category width.

 

if you have many on your X-axis you can create hierarchy like Dates to drill down.

No I need to show all the X-axis dates in one chart

 

also changing the xaxis from continous to categories will give you less data points.

If we change Xaxis date to continous , the Y axis will not be a raw data we need to select a agg function , I dont need this to happen

 

reducing font size also we can add more categories and try to reduce the scrollbar horizontally. 

I have 30L rows , so was trying to figure out a way like we do in excel by selecting minimum and maximum date values with some intervals so that all the dates will be visible and also the Y axis will be a raw data without any agg function

 

Thanks 

Ravishankar

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors