Show Week End Date on Continuous x-axis instead of Week Start Date

[khyry]

Hi community,

I have a graph with data by Week End Date. I want all the data to fit without the need for a scroll bar, so I have the x-axis set to continuous:

Continuous x-axis, all data fits without a scroll bar

However, when you filter the graph to show only recent data, the x-axis shows Week Start Date instead of Week End Date:

Continuous x-axis, the Week Start Dates are displayed instead of Week End Date

Changing the x-axis to be categorical fixes this for when the graph is filtered, but now the graph has a scroll bar.

 Categorical x-axis, the Week End Dates are displayed, but there is now a scroll bar.

Is there any way to keep the continuous x-axis and change it to show Week End instead of Week Start? Or is there some other way to have no scroll bar and the data labeled by Week End Date?

[khyry]

@amitchandak Thank you for your response! I am using a Week End Date Column (week ending on Saturday):

Week End Date = 'Date'[Date] - WEEKDAY('Date'[Date]) + 7

My problem is that the users of the report want the whole graph visible (as in, no scroll bar), but also want to see the Week End Date on the x-axis when they filter to show a smaller date range. Is there a way to do this? Or do I have to choose between displaying Week End Date or having the whole graph visible?

[v-jingzhang · Accepted solution]

Hi @khyry 

I'm afraid you have to choose between displaying Week End Date or having the whole graph visible. Currently when the axis is continuous, it is decided and adjusted by the axis data range and visual size automically. We have no control on that. When it is categorical, it depends on the data in your table and displays all the values on the axis. It cannot be compressed automatically. 

I found some clear explanations from the following links:

X Axis scrolling | Power BI Exchange (pbiusergroup.com)

7 Secrets Of The Line Chart | Power BI Visuals | Burningsuit

In addition, there are some ideas similar to your requirement. You can vote them up:

Microsoft Idea - Allow Formatting of Dates in X Axis with Continuous Data

Microsoft Idea - No scroll bar in Line or Bar Charts (Continuous vs. Category)

Microsoft Idea - Zoom for continuous X-Axis in line charts.

Microsoft Idea - data label density on all charts

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[khyry]

Thank you for your response! We have decided to group the data by Week Start Date instead of Week End Date so it aligns with the graph, and we addeed Week End Date to the tooltip.

[amitchandak]

@khyry , Are you using week start date/end date column or date column

example

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

You should prefer to use categorical axis in this case