How to show all records in line graph without scrolling bar

[IvanS]

Dear all,

I would need your help with showing all records in month without necessity of scrolling. I have date table with date colum as unique values.

The first graph is using the unique date from "Date" column.

The second graph is using "Date" from created Date Hierarchy (Year, Quarter, Month Name and Date).

As you can see, the data are correct in both graphs however the second graph is having scrolling bar. I have noticed that this issue occured only for button "Expand all down one level in the hierarchy" (below). For another one ("Go to the next level in the hierarchy"), the records are already wrapped.

Is there any way how to wrap the data using "Expand all down one level in the hierarchy" so the users do not have to scroll?

Thank you in advance

Ivan

[mahoneypat]

Please see this article for a good way to address this.

Creating a simpler and chart-friendly Date table in Power BI - SQLBI

Pat

[amitchandak]

@IvanS , Please change the Axis type to continous and check if that can make a difference

[IvanS]

Hi @amitchandak ,

after swiching the X axis to Continous, settings are automatically reverted back to Categorical.

I.