Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Merging Queries using SharePoint lists

  Hi All, I am working on a project where majority work in based on Power BI reports. These are the customer requirements.   I t’s a basically of the HR system where HR managers for specific r...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi Anonymous,

     

    1. You can add Region to the Legend of the visual.

    2. Do you have any source data? You only have summarized data in the HR Dashboard. How to update the totals? The formulas of turnover have to be hardcoded.

     

     

     

     

     

     

    3. You can delete the old relationships and rebuild new ones. Or double click the relationship to make changes. 

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    4. To be honest, it's easy to create a visual. Drag the columns to the fields. 

     

    Best Regards!

    Dale

Anonymous's avatar
Anonymous
Not applicable
9 years ago

v-jiascu-msft and Dale ...

 

Sure ...I will supply the sample shortly what the client is looking for 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

v-jiascu-msft 

 

Client is looking for regional dashboards (Indonesia, Thailand, Singapore, Japan etc.) and GLOBAL Dashboard (All Regional) 

 

These are samples of GLOBAL Dashboards 















These are sames of Regional Dashboards 












Please Advice how could use my design to gerenarte these charts and dashboards? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Regional Dashboards such as Indonesia will have its own Indonesia subsidiaries which I have indicated as BU1, BU2, BU3 etc.  

    Each Region SHOULD NOT be able to view other regions such as Japan, Thailand etc. for the confidentiality purposes but the GLOBAL HR should be able to view all the regions.

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi Anonymous,

       

      To be honest, I can't do much without source data. Only some suggestions.

      1. Creating visuals could be easy. Drag columns into fields. 

      2. Calculated columns and measures could be needed.

      3. How do you want them to use the Dashboards? Create dashboards themselves? Or share to them and view only?

      4. You can apply RLS (Row-level-security) to separate the regions. 

       

      If you can provide the dummy PBIX file (your file with four tables), that would be great. 

       

      Best Regards!

      Dale

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        v-jiascu-msft and Dale. 

         

        Totally got you ...

        Will provide the PBIX file with sample data shortly ...

         

        Thanks a ton!