Forum Discussion
mnt23
Helper I
Helper IVisualisation showing numerical day, rather than full date.
Hi, I'm pretty new to Power BI and I'm trying to do some basic visualisations. I have a number of jobs that are closing down as the year goes on. In my data, these each have their own row, with ...
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.
