Show all dates on x-axis with custom hierarchy

[PiterBI]

I added a custom date hierarchy to the x-axis a table. So that I can see the month, day of the month and abbreviation of the day. However as a result the days without any quantity are not shown on the x-axis. See first image. I want a continuous x-axis; to see weekend days eventhough there is no quantity. Is it possible?

The columns are respectivitely text, number and text. Thus, not recognized as date. If I have the x-axis set to a regular date there is an option to select the x-axis type and set it to continuous. This is the case for the second image.

[Anonymous · Accepted solution]

Hi @PiterBI ,

If the columns in your table are not recognized as dates, then Power BI may not be able to display a continuous x-axis with all dates. Please try the following methods:

1. Change the data type of the columns to dates: If the columns in your table represent dates, you can try changing their data type to dates. To do this, select the column in the Fields pane, click on the Modeling tab in the ribbon, and select the Date data type.
2. Use a date table: If you have a date table in your data model, you can use it to create a continuous x-axis with all dates. To do this, drag the date column from the date table onto the x-axis of your visual. Then, in the Visualizations pane, click on the Format tab and select Continuous for the X-axis type. Creating a simpler and chart-friendly Date table in Power BI - SQLBI

Best Regards

[PiterBI]

I linked a data table in my model, but I used the data column from the original table. I learned that when a one-to-many connection is created, the date hierarchy is removed from the many side. 

So indeed option 2, use the date table was the solution. Thank you.