Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 th...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ，

     

    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

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Anonymous ,

 

This is not enough for answering your query.

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

 

Thanks,

Pragati