Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Matthew Paul]

Hello,

It’s driving me crazy, but I have missing bars in my bar chart where I know there should be a bar.  

I want to track the new registrations from my website every day, summing up the new registrations over the previous 7 days, so I created this measure:

WeeklyRegistered = CALCULATE(

  DISTINCTCOUNT(users[userid]),

  DATESINPERIOD(users[register_timestamp_PST], LASTDATE(users[register_timestamp_PST]), -7, DAY)

)

Works great for the most part.  However, in my data set, I have a few days where there were no new registrations on that day.  When I go to chart this out with the date along the X axis, all of the days have the correct info except days where there were no registrations.  Instead of still summing up the previous 6 days which did have registrations, I just get an empty space in my chart.  Looks like this:

Any help would be useful.  

Thanks.

——————————
Matthew Paul
Snohomish, WA
——————————

[Vincent Lacomme]

Hi Matthew,

In your Power BI model, do you use a distinct date table (connected to your fact table) ?
This is most likely the reason of these blank spaces.

More on that there : https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

——————————
Vincent L.
Chartered accountant – Expert-comptable
——————————
——————————————-