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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gobrien06
Frequent Visitor

Bar Chart Showing "Blank" Month

Hi, 

 

I have a bar chart where I am trying to show the Total Quantity of Items sold per month, by category. I have a sales data table that has the Total Quantity and Item Category columns, and a date table. The sales date column from the sales data table is connected to the date table. 

 

The visual I am trying to make is Total Quantity Distributed by Month and Category. However, when I add Month to the X axis, Total Quantity to the Y Axis, and Category as the Legend, the visual shows a "Blank" month - despite there being NO blank sales dates in the sales data table.

This problem does not occur if I use Year from the Date table, instead of Month. 

Screenshot 2023-06-08 133930.pngScreenshot 2023-06-08 133909.png

1 ACCEPTED SOLUTION
gobrien06
Frequent Visitor

The error was occuring because the date table was using 00:00:0000 as the time, while there were dates in my sales data table that had a non-zero time. I resolved the issue by going into the query editor, and changing the column type to Date (and NOT Date/Time). This had to be done from within the query editor. 

 

More information: https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-Hierarchy-shows-Blanks-in-Visua... 

View solution in original post

3 REPLIES 3
gobrien06
Frequent Visitor

The error was occuring because the date table was using 00:00:0000 as the time, while there were dates in my sales data table that had a non-zero time. I resolved the issue by going into the query editor, and changing the column type to Date (and NOT Date/Time). This had to be done from within the query editor. 

 

More information: https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-Hierarchy-shows-Blanks-in-Visua... 

nvprasad
Solution Sage
Solution Sage

Hi gobrien06,

 

The only reason i could think of is "Blank rows in Month column in Calander table".

 

Could you please check ? 😊

 

Appreciate a Kudos! ‌‌
If this helps and resolves the issue, please mark it as a Solution! ‌‌

Regards,
N V Durga Prasad

Hi, there are no blank rows in the date table, or in the sales data table. Additionally, I am using the Date Hierarchy feature, so the date table only has one column for date. 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

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.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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