Showing results for 
Search instead for 
Did you mean: 

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


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:



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)



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.




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.



Helpful resources

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 155 members 1,883 guests
Please welcome our newest community members: