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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
makarama
Frequent Visitor

My Date column has values available up to date (15/1/2025) but all values for 2025 are shown.

My Date column has values available up to date (15/1/2025) but when I use it in a view on the x axis dates appear for the full 2025. Even when I create a list view of that column, the same happens.

 

makarama_0-1736947414627.png

makarama_1-1736947455228.png

 

makarama_2-1736947478963.png

 

3 REPLIES 3
ToddChitt
Super User
Super User

Go to the Model view and create a new Layout by clicking the [+] next to [All tables]. Add only the relevent tables to the page. Take a screenshot. 

To to the Data tab. Click on the table that contains the [End Time] column. Take a screenshot.

What about the measures? Are there DAX calculations involved? We will need those as well. 

The more information you can give us about your model, the better chance we have of helping you.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





ToddChitt
Super User
Super User

We need to see more of the data model. Can you show the table layout with relationships, maybe more of the Date dimension?




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





But I showed you the date column. The most recent date is 15th of January. But when I create a table view of this specific column only then I get dates for the full 2025. It's hard to share the relationship view because I have more than 20 tables in this dashboard.

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!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.