Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Interactive Item on Dashboard

Hi!   I was wondering if we have an option in power BI where I can manually set the status of an item to either Red/Yellow/Green light from a drop down.   For Example :   1. Status of Document ...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous powerapps is your solution, full stop. otherwise, you will keep going on circles and spend time here looking for a solution. Just a friendly suggestion.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi1

 

Thanks for your answer, unfortunately that wont be applicable in my scenerio, I just want those threee traffic light signals that I ahve in the screen shot provided to activate when any one is clicked and the other two to be deactivated, for example if red is clicked , the green and yellow should be deactivated and so and so forth.

 Thanks

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous powerapps is your solution, full stop. otherwise, you will keep going on circles and spend time here looking for a solution. Just a friendly suggestion.

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks, I was able to make it functional with the powerapps, looks good and functions well.

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

      Anonymous glad to hear. you follow the right path and you have the solution instead of going in circles here. Well done. Keep up the good work and keep sharing how you solve your problem/challenges.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks Parry. Is this this the right forum for security related query on the powerapps. Well the thing is that I can share the app that I created and used on the PowerBI. The issue is anyone can get onto the Power BI report (who has access) to go and chnage the traffic light signal. I want to be able to restrict the edit access to only a couple of people and rest ca just view the Traffic lights.

        The way this app works is I have a Sharepoint table created with Traffic lights indocators(1,2,3) against each item and each click on the Power BI report registers the key and updates the SharePoint table with the specified click. I am not sure how will I restrict edit access to just few ppl and all others only view access.

         

        Any suggestions on this please.

         

        Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you so much Parry, yes I guess thats the only solution for this I guess. I am creating the power app for that now and it functions exactly the way I wanted. Just that it does not display it in full page, it has thick sidings on each side.