Forum Discussion
Helper ILast row from dataset is missing in visuals
Hi, ammeijs
I’ve opened the sample pbix file you uploaded. Then I found that the last value displayed in the card chart is 2020/11/24, which does not have any problem. Would you like to check the pbix file I opened and find if it has any difference between yours?
Maybe the filters are reset when I open your report?
You can download the test pbix file I downloaded here
I suggest you to clear the page filter, report filter, and visual filter to ensure your data is not filtered in any way.
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, ammeijs
In my opinion, when you select “Last value” in the card chart. The “Last” doesn’t mean the last row of data in your dataset. It means the last of the value of the column sorted ascending by value(sorted by the initial letter if it’s text type).
In my test, I sorted the table by ID in my dataset, you can see the name beginning with Z is the first value:
When I created a card chart and select “Last name”, you can see the name beginning with Z is the last name because it’s initial is at the last:
You can download my test pbix file here
More info about card chart in Power BI
If you still have a problem, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.