Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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).
Solved! Go to Solution.
Tks Tom, the problem was solved using a Index Table and a DAX formula.
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.
Tks Tom, the problem was solved using a Index Table and a DAX formula.
That's great! Also looks great too!
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
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!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |