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

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

Hi Anonymous,

 

The relationships could be wrong. Though they are all called "ID", they have different meanings. If we establish proper relationships, we don't need to merge the tables. We can create some measures and plot them in the visuals. Could you please post a sample in TEXT mode? The dummy PBIX file would be great. I can't give any more suggestions without a sample.

 

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.