Bar plot using only the latest data of a column with diferent records

[DorianRodrigo]

I have a table (time relation)  about oil rate production for several wells and I need to do a bar plot using only the latest oil rates (OIL_VOL_RATE) for the Top Ten oil producers. This plot must be updated for each day, because every day we have new production data for some wells (not every well can be test daily). 

[tom480]

It's still a scheduled refresh, right?  Here's a scheduled refresh from SQL source once a day.   Go to your dataset in Power BI service and setup scheduled refresh.

[DorianRodrigo · Accepted solution]

Tks Tom, the problem was solved using a Index Table and a DAX formula.

[tom480]

That's great!  Also looks great too!

[tom480]

Hi @DorianRodrigo ,

If you save this excel file to OneDrive and setup a scheduled refresh (daily), you can achieve the deserved results.  For the bar chart, use your filters and select the top 10 (sample bar chart with different data shown below).

If this helps, please mark as a solution!  Always glad to help!  Tom

[DorianRodrigo]

the data is conected to a SQL server, the data is updating each 24hrs, I need an option to automate the plotting, maybe a DAX to get tha latest data for each well and make the bar plot. Thanks Tom!!