Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
Line Chart output (the dotted line is just a constant):
Solved! Go to Solution.
SOLVED
More googling led me to the "Show items with no data" option on my Axis object.
SOLVED
More googling led me to the "Show items with no data" option on my Axis object.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |