Forum Discussion

skjellter's avatar
skjellter
Frequent Visitor
4 years ago

Notification change in ranking

Hi all,

 

I have made a ranking (with a Matrix) with all the results of colleagues over a certain period. This ranking changes when a deal is closed and it is shot into Power BI (via Azure Data Factory) via our CRM system.

 

At the top 3 I have added a badge (icon) to show that they are 1st, 2nd and 3rd in the ranking. Now I would like to be notified (preferably in MS Teams and via Power Automate) when there is a change in the top 3.

 

Do you have any idea if this is possible and how I could do this?

 

I've looked at Power Automate for a while, but I couldn't find the solution there.

 

I like to hear it!

 

Cheers,

 

Kjell

 

 

 

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    "when there is a change in the top 3"

     

    Power BI has no memory, and no concept of global variables. You need to do that outside of Power BI.  You can run DAX queries in Power Automate but even there you need to have some way of storing the previous result.  Good luck with that...