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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

how to show missing data on daily and weekly

Hello,

 

I created a report that show time evolution.

When I use the date Hierarchy to show monthand quarter I can easly select the option "Show items with no data" and them I can see also months where there is no data. 

When I try to do the same on days, there is no data anymore juste x axis with number from 1 to 31 and it does not makesence since my report is over many months. So I add to create a group and make bin that are daily based. But then when I select show items with no data on this daily group nothing happens, I can not see days without data. 

I have the same problem i I want to see weeks... I have to create a new group and then when I select the option show items with no data nothing happens. What should I do in order to able able to see days and weeks without data like I see in month and quarter?

Many thanks for you help with this!

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , You can add +0 to measure or use this option

ShowItemwithoutdata.JPG

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

I did both already...

@Anonymous 

Could you please show some sample data which can reproduce this problem or provide a sample PBIX file so that we can investigate it further? Thanks.

 

Best Regards,
Community Support Team _ Jing Zhang

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Kudoed Authors