Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I use Power BI for my Stocks Analysis. Here is the very dashboard I use, it shows all the analysis I do when considering which stock to buy and allows you to compare companies.
Enjoy!
P.S.> It is updated daily with live stock price.
eyJrIjoiZDQ5MDZjOGItMmE4Yi00N2UzLWJlMjUtYmRiZGYxNDk0NDQ5IiwidCI6IjgwZTlhM2Y3LTZhNTQtNDQ2OS05NTlhLWQ2MWFhNTM4Y2M4ZiIsImMiOjh9
How did you create the bar at the top based on the measure that filters the chart below?
Dear Michael,
You did an excellent job. I need your guidline that how scroll works with live data of stock market. I want to take live data from https://www.psx.com.pk/. Please help me, if you can share pbix, then it will be more helpful for me. I also added soem template on the Data Stories Gallery, please find the link given below:
Regards,
Jamal Qamar
Hi Jamal
I'm trying to build a similar dashboard for PSX stocks. Is it possible if you could me from where were you able to fetch the data?
Thanks,
Shayan
Hi Jamal,
Thanks for the kind comment.
We had to have a developer do the backend aggregation of the daily stocks data and warehousing them on a cloud SQL server database which the Power BI dashboard connects to in pulling data with daily scheduled refresh.
I looked at the Pakistan Stock Exchange link you provided, it doesn't seem to have a list of stocks and their prices. You might need to buy an API access from them or someone else for that data.
Regards,
Michael