Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Issue with Visual Level FIlter Top N not working in Service

I have a dataset that is refreshed daily at noon and at 5:30 pm. So I have a visual that is supposed to display the latest updated figure. This worked when I applied the Top 1 filter by the latest ti...
Need Help
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,

 

I would do the last refresh date in Power Query:

How to Add the Last Refreshed Date and Time to a Power BI Report (enhansoft.com)

 

Like this you are not dependent from the data, but it really shows the day/time when the report was refreshed. Otherwise, once there is no new data you don't know if the error is in the data or in the refresh. Like this you see if the report was refreshed or not.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, thank you for your suggestion. But in my case, there is no problem with the data being fed into the report adn the refresh part. It's really the problem with the top N filter not being applied in the service when I have put the filter in desktop. This has caused the visual to display a summed up data instead of the latest data.