Visualisation showing numerical day, rather than full date.

[mnt23]

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 a date that that close down. 

I'm looking to plot the number of open jobs over time. After some searching, I found a thread here that I thought answered my questions. However, following that I had 2 issues:

1. When displaying the data in a visualisations, moving down the heirachy to day, it displayed it as days 0-31, and it just had the maximum total - why isn't it displaying as actual dates? (i.e. 21st June 22 there are 18 open jobs).

2. Is there a way to get the measure to return 0? So that the visualisation drops all the way to 0, rather than just ends when there are no more jobs open. 

I've scrubbed my data and have the essential bits of the pbix here. 

I'm sure there's an easy fix to this and I've probably just got a setting wrong, but any help would be grateful!

[Seanan · Accepted solution]

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.

[mnt23]

Thanks @Seanan that was exactly what I was looking for. 

[Seanan]

@mnt23 No problem! Glad I was able to help.