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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
vijay22kar
Helper II
Helper II

Set default time at x-axis

Hi All,

 

I want to set the time on the x-axis in the line chart starts from 11.00 PM to 7.30 AM. How to set. Please check my below graph.

 
 
6 REPLIES 6
vijay22kar
Helper II
Helper II

Hi All

I want to set the time on the x-axis in the line chart starts from 11.00 PM to 7.30 AM. How to set. Please check my below graph.

 

time_change.png

 

Hello! Did you get a satisfactory solution to this - so you could carry on using a line chart? I have a similar need, due to using a fairly wide date-filter to allow calculation of previous year's values alongside the current year's. But I want the user to focus on far RHS of the chart to view values for the current and recent months. It would be nice if Power BI allowed me to preset the position on the x-axis scroll, so it automatically displays the far RHS. I remember being able to do this in a previous BI tool (not Microsoft).
Thanks for any input ... anyone?
BR Mark

Tahreem24
Super User
Super User

@vijay22kar ,

 

That Scale Type Linear id supported in Stacked Bar chart column. Your requirement is for Line Chart. So In Line chart Scale type Linear is supported in Y-Axis Only. So you can do one of below approach to achieve your need:

Approach 1: Swap your scale in Line Chart. i.e. Put Time on Y-axis and other field in X-axis. As Linear Scale Type is only supported in Y-Axis of Line Chart.

Approach 2: You can replace Line Chart with Bar Chart and Set your default axis in X-axis itself. (Refer my prevoius reply)

 

Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

@vijay22kar , If my reply helped you so please give THUMBS UP for support and also mark it as a solution so it may help other member to find it more quickly.

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Tahreem24
Super User
Super User

@vijay22kar ,

 

Find the below screen shot for your reference:

 

Capture.JPG

 

Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
rajulshah
Memorable Member
Memorable Member

Hello @vijay22kar,

You can set this from 'Format' pane of the visual.

Go to Format > X axis and then specify Start and End values.
same X axis.png

 Hope this helps.

 

Helpful resources

Announcements
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!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.