Last row is missing from visuals

[ammeijs]

Hi all, 

While trying to fetch the last value or all the values from the selected period, still one row gets excluded from the visuals: the last row. 

- The dataset is just refreshed (from webconnection) and is complete while checking it in data query

- The rows are ordered properly 

This is happenig with two datasets and the others are just working fine. So, I do not know what is going on. 

This is whats happening: 

The next table is showing all the values, except November 24th 2020. The filter above is till December 31st, so it must be concluded. 

Data QueryVisual dashboard

If I count the rows with the measure, all the rows are accounted for. However, when I use a card and choose 'last value', it does not show the last row of the dataset. 

Can someone explain what is going on? 

Thanks in advance. 

[ammeijs]

@amitchandak datatype is date. 

This is my .pbix with the data and such: https://bit.ly/2MI5eTj. 

Thank you! 

[v-janeyg-msft]

Hi, @ammeijs 

It’s my pleasure to answer for you.

According to your description, I downloaded your file, but there is no problem and everything is normal.

Like this:

However, the last value will change with the change of context, such as the date slicer. If you want to display the last value fixedly, you can create a measure.

Like this:

Measure = CALCULATE(MAX(Persvragen[Datum]),ALL(Persvragen))

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ammeijs]

@v-janeyg-msft First, thank you for your help.

Now, I am confused haha. Why does the 24th of november shows up in your table (left) by doing nothing, and not in my dashboard?

However, it is not about how to extract the last value. It happens that the last value does not appear in my dashboards/visuals from some reason.

I only use a date slicer, but the 24th falls in the period I selected (1-10-2020/31-12-2020). To use ALL in a measure is therefore not the right solutions because the visual should react on the slicer. 

[v-janeyg-msft · Accepted solution]

Hi, @ammeijs 

Please download my file,don't modify it after opening it, and see if 11.24 appears.

You may have changed something, but it is not shown in the sample you gave. I noticed that your date table uses the date column in the third table, which may lead to incomplete dates when establishing a relationship with the second table.

You can try:

Kalender = CALENDAR(min(Persvragen[Datum]), max(Persvragen[Datum]))
 or
Kalender = CALENDARAUTO()

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@ammeijs , check the datatype, it should be date.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.