Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Project Management Dashboard

https://app.powerbi.com/view?r=eyJrIjoiOTMxMzNjZjItYTVmOS00NmUzLTljZTAtY2JjMGZlNWUyMzEzIiwidCI6ImRmMmE5NTE1LTk5ZGItNDY2Zi1hM2E0LTI5ODY0MDVmZjQ4OSIsImMiOjN9 Need your suggestions on how I can improve...
Dashboard
  • ashishrj's avatar
    ashishrj
    10 years ago

    Anonymous A few suggestions from my end:

    1. Page 1 seems to be perfect ! Fantastic work 

    2. Page 2: Try making maximum visual to filter data when clicked on any other visual

    3. Page 2: Issue Register By Priority - Give different color based on priority (like red for critical, yellow for medium, green for low, etc)

    4. Page 2: Sort Month for Financial Report Plannes Vs Actual and if possible label data 

    5. Page 3: Deliverable Notes word cloud visual does not make much sense (from my point of view) for the data you have now

    6. Page 3: Try fitting Project Delivery Timeline in single view without much of scrolling (may be at bottom)

    7. Page 3: Project Wise Deliverable status & Assigned to Deliverable status...make color code same for both (like red for closed)

     

    Overall good work and appreciate your efforts Rinky. All the best !

shamsuddeenvp's avatar
shamsuddeenvp
Post Patron
10 years ago

Nice Anonymous

 

Can you please let me know how can 

 

Change dynamically the Green/red arrow images. Also highlighting he tabs etc.

 

Br,

Shamsuddeen

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Hi,
The green and red arrow are web url. So i have used a calculated column, where i have put web url for upward arrow image when a certain condition is met and downward arrow image url if condition is false.
Formating the tabular grid. This feature is now available with power bi after april update. Switch to layout section. There you will see Column Header and Value . Where you can define the font colour as well as background colour. If you need further help on this, kindly share your email. I shall send you the screenshot of datamodel and formating of tabular grid
  • shamsuddeenvp's avatar
    shamsuddeenvp
    Post Patron
    10 years ago

    Thanks Anonymous

     

    It would be great if you could share [email protected]

     

    Thanks a lot

    Shamsuddeen

    • shamsuddeenvp's avatar
      shamsuddeenvp
      Post Patron
      10 years ago

      Hi Anonymous

       

      I tried to get the green and ed arrow changed dynamically based on the measure value. However I am not able to get the image in report, just gets the url string alone once drag the field.

       

      It would be very helpful if you give some insight how you accomplishd this.

       

      I tried to mimic the below link approach as well without success.

      http://sqljason.com/2015/11/custom-indicators-in-power-bi-using.html

       

      Br,

      Shams

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago
        Hi,
        In the data modelling tab. Under Model tab. You will find a field Category. Image Url is one of the options. Select the column where you have added upward arrow and down arrow url. Change the category of the column to image url. It will render the image in report view
  • pvz's avatar
    pvz
    Frequent Visitor
    10 years ago

    Hello Rinky, Is it possible to share the right URL for your dashboard. For some reason i see no content available.

     

    Thanks!

    Paul