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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
fackert18
Frequent Visitor

X-Axis Dates Missing Even with Date Table

I'm struggling to understand why I'm missing dates on my x-axis even though I'm using dates from my Date Table. 

 

In my model, I'm joining DimVendor to Capacity, then Capacity joins to DimDate on a standard date value (yes, DimDate is marked as the date table). 

 

On my report, I have a slicer, limiting DimVendor to a single vendor. Then a relative date slicer. No other filters on the report.

 

My line chart visual uses a Year-Month hierarchy for the x-axis, then a measure that simply sums a Capacity column (this measure is located in a measures table). You can see from the images that I'm missing November & December 2020 in the chart. This vendor doesn't have any data for those months in the Capacity table, but I would expect the months to show on the chart.  Does it have something to do with how my data model is structured?

 

Data Model:

 

2021-08-09 13_30_54-Carrier Scorecard - Power BI Desktop.png

 

Line Chart output (the dotted line is just a constant):

 

2021-08-09 13_56_31-Carrier Scorecard - Power BI Desktop.png

 

 

1 ACCEPTED SOLUTION
fackert18
Frequent Visitor

SOLVED

 

More googling led me to the "Show items with no data" option on my Axis object.

 

2021-08-09 14_16_46-Carrier Scorecard - Power BI Desktop.png

 

View solution in original post

1 REPLY 1
fackert18
Frequent Visitor

SOLVED

 

More googling led me to the "Show items with no data" option on my Axis object.

 

2021-08-09 14_16_46-Carrier Scorecard - Power BI Desktop.png

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.