Date_Daily Production to have full month continuous dates

[Anonymous]

Hi

Im building a report for Daily Production Report.

In the X Axis when teh current date is 11th, then the report will be displayed only from 1 to 11. where as the X Axis 12 to 31 is hidden. Is there a possibility to show the whole month date in X Axis even if teh values for those dates are ZERO.

Faisal

[CNENFRNL]

@Anonymous , what's your measure to calculate daily production? Then add +0 at the end of the formula to force blank turning to 0 like this,

Total Daily Production = SUM ( 'Table'[Qty] ) + 0

[Anonymous]

Hi

There is no measured value. In my database against the date of production, we get the production data directly in the table.

[daxer-almighty]

@Anonymous,

In a professional PBI report there's no place for implicit measures. Please manually create all measures that you need and hide all the columns that could pose a possible temptation to use them for implicit measures. Trust me, this is a piece of best advice you can get from a long-time professional. Once you have the measures, do what @CNENFRNL asks you to.

[Anonymous]

Hi

This is how we need