cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Missing data in a table

I have a table in my Power BI to show selected data from the past 7 days. However, if there are empty columns in the data set (not the date or order number) then it doesn't show up at all.

 

Any thoughts?

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Gingerclaire_ ,

 

Did you create a date table that has consecutive dates and contains all the dates in the fact table? Create relationship between date table and fact table. Then use date column in date table and select 'show item with no data' for it.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

View solution in original post

4 REPLIES 4
Super User II
Super User II

Hi @Gingerclaire_ ,

 

This is not enough for answering your query.

Share some screesnhots around sample data, visuals and the output expected.

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Super User IV
Super User IV

@Gingerclaire_ ,

It does not have date the difficult to show. If you join with date table it will show a blank date 

or

Use +0 on a measure or use this option if you joining the tables

ShowItemwithoutdata.JPG

 

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@amitchandak @Pragati11 Annoying just ticking 'show items with no data' doesn't solve the issue. 

 

The data will always have a date it is column such as part number or component type that could be blank. 

Hi @Gingerclaire_ ,

 

Did you create a date table that has consecutive dates and contains all the dates in the fact table? Create relationship between date table and fact table. Then use date column in date table and select 'show item with no data' for it.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors