Forum Discussion
Helper IVisualisation showing numerical day, rather than full date.
Hi mnt23,
You may find it more beneficial to change the X-Axis from a date hierarchy to just display all of the data and then using a slicer to drill down into the year, month or day (See below).
In order to get your measure to return 0 for days that do not have jobs open, create a new measure using the following code:
Total IAs = IF('IAs'[Total IAs] = BLANK(),0,'IAs'[Total IAs])I hope this helps you with what you are looking for.
Solution SupplierHi mnt23,
You may find it more beneficial to change the X-Axis from a date hierarchy to just display all of the data and then using a slicer to drill down into the year, month or day (See below).
In order to get your measure to return 0 for days that do not have jobs open, create a new measure using the following code:
Total IAs = IF('IAs'[Total IAs] = BLANK(),0,'IAs'[Total IAs])
I hope this helps you with what you are looking for.
