Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Regular Visitor

Equity Trading challenge

Good day all!

We have a use case I'm not sure is possible with power bi but thought I would ask before we code it manually.


We have a recommendation engine looking at the entire stock market every few minutes running on python, this write table that has a matrix visual connected to it that is updated every minute or so on premium capacity.  There are a group of traders that are watching this (among other things) and they want to in some way highlight a specific equity(s) for everyone else on the team to look at before they decide to buy.   So all the other traders would somehow be alerted to something another trader liked to review.


I honestly have no idea how to do this.  Maybe two Matixes, the top one full with hundreds of rows of equities and the bottom empty, we want to copy or move or duplicate in some way one row from the top matrix to the bottom matrix. Or any other ideas you have to highlight the equity(s) so everyone can be aware instantly that we want to buy.  Think of it as a wish list that of the hundreds of recommendations the ones that have been reviewed get moved to the wish list. And then can be removed from the wish list as well when they buy or decide not to.


Is this even possible on power bi?


Thanks for your time and ideas!

Solution Supplier
Solution Supplier

@UpNorth  Thanks for sharing your query.


1. For your use case, you can create a dashboard with KPI and set alert. However, the alerts are checked once a hour or after 24 hours. Snapshot below:


2. Second, I can think of your Power Automate to check the value every minute/second as per requirement and then you can set alert using email or if their are any messaging service for your client. I believe you can integrate that.

Will let you know if I come across anything else.

** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !

Good Luck 👍


Thank you ghoshabhijeet,  the challenge is that we display in a matrix in rank order the equitys we recommend buying then user input identifies which ones move to the wish list.  eg. clicking, dragging, checking, highlighting,  ....  something.  thats the part we are stuck on.

@UpNorth Thanks for your reply !


I am afraid there is no ready solution available in Power BI that I know of or if its there, I am not aware of. Will let you know if I come across anything.

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors