Show dates with no data in a Visual

lordmukund , +0 will work with date table, Please create a date table and join with that and use that on x-axis

Then Measure +0 will work

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Hi, lordmukund 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

Calendar(a calculated table):

Calendar = CALENDARAUTO()

There is a relationship between two tables. You may create a measure as below.

Result = DISTINCTCOUNT('Table'[Work Items])

Then you need to use 'Date' column from 'Calendar' table and check 'show item with no data'.

Best Regards

Allan

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