Forum Discussion
Last row is missing from visuals
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 datatype is date.
This is my .pbix with the data and such: https://bit.ly/2MI5eTj.
Thank you!
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.
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.
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.