Forum Discussion
Handling blank values between dates
Hello, I've got a problem with handling blanks between two dates. I've got a measure that sums up the amount of hours in my fact table. This is filtered by a relative date slicer. The picture b...
I have fixed my issue by not using a date hierarchy but just a calculated column with year and month instead.
I could then use the "show items with no data" option.
Hi Anonymous,
Another solution is enabling "Show items with no data". Please refer to the snapshot below.
Best Regards,
Dale