Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyBI'ers
Q: Is it somehow possible to automatically track a development on specific measurement points each time you press update for yorur data from a external source?
Example:
Let’s say a have some sales figures that are revised each 14 day. When I press “update” and collect the new data, I would like to add this number/value to a trend diagram or curve with the specific date for updating on the x-axis. I would also like to have some kind of visual indicator that the summed sales number is within an upper or lower target limit/value. Is that somehow possible to do in Power BI.
Solved! Go to Solution.
@Anonymous By update you mean refresh right ? If yes then data refresh within power bi is not delta but full. Therefore each time you hit refresh dataset in power bi will be replaced with what is in your data source so if in your data source historcal records are not present they won't appear in power bi. Incremental data loads (so power bi stores history records) is something suggested as an idea for power bi and you need to keep an eye here on when it will be out.
@Anonymous You can now add indicators within power bi desktop by going to Analytics icon (next to paintbrush icon) and selecting min, max, avergae or constant lines.
@ankitpatira I know about the tendency lines, but do you know how I can automatically make a data point in a graph each time I hit the update button?
Example:
Lets say I have some sales figures on some different people:
Each time I press the update button I want Power BI to automatically store the historically data including the sum on sales on y-axis and the current date on x-axis like this:
@Anonymous By update you mean refresh right ? If yes then data refresh within power bi is not delta but full. Therefore each time you hit refresh dataset in power bi will be replaced with what is in your data source so if in your data source historcal records are not present they won't appear in power bi. Incremental data loads (so power bi stores history records) is something suggested as an idea for power bi and you need to keep an eye here on when it will be out.
@ankitpatira Yes, by "update" I mean "refresh" and it is the delta I would like to have view on in a graph each time I refresh the data. It would be a great feature in Power BI.
User | Count |
---|---|
91 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
72 | |
60 | |
59 |