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
DavidNunes7
Helper I
Helper I

How to show all dates in your visual, regardless of whether or not they actually exist in the table.

I have a fact table and a calendar table.

My fact table does not have values for all months but I would like the x axis to show the months

How to show all dates in your visual, regardless of whether or not they actually exist in the table.

 

 

 

fato.png

1 REPLY 1
HotChilli
Super User
Super User

x-axis should have months from date dimension.

The measure that is in values well should be altered to return a value for all inputs.  Usually done by adding 0 (zero)

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!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.