cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

DateTimeTable not showing on x-axis for NULL measures? (How to show periods with no data)

Hello,

I have a PBI report where I am measuring samples hourly.  In this case, visitors to the website, registered memebers vs guests.

 

I found that when I try to graph periods of NO visitors/count = NULL that it becomes difficult to show that.

 

I have two tables: DateTimeHourly that has one entry for each hour of each calendar day and another SamplesHourly that ONLY gets a row added if a sample was collected/recorded that hour.

 

 

 

Here is what see:

NoTally.PNG

 

Then if I add a simple measure on the DateTime table to show a 1 for each row of the DateTimeHourly table which is my date dimension (one row per hour)

WithTally.PNG

 

How can I achieve that without having to add a "Tally" measure?  I would have thought using Show Items With No Data would accomplish that, but it had no impact.

 

It seems like I should be able to see all the times that no data was collected over the X-axis?

 

I am using a datetime table so there is 1 row for every hour, as opposed to not doing there where I could understand that it may not show entries if there is nothing in the system for hours before or after a certain time.

 

DataTableRelationship.PNG

 

I can upload my PBIX file..if someone tells me how to do that.  I don't see the normal upload options anymore.

 

 

Here is what happens though: 

 

When I try to use the Sparkline custom visual (or any similar one) it appears as if all data is accounted for, however, as we can see there are large sections of the x-axis where NO data was recorded.  I want to show that as line breaks so the user doesn't think everything was all good and proper when it was not.

 

SparkLine.PNG