Forum Discussion
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
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.
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
Hello vijay22kar,
You can set this from 'Format' pane of the visual.Go to Format > X axis and then specify Start and End values.
Hope this helps.
Find the below screen shot for your reference:
Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!
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!
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.
