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

Thanks a ton v-jiascu-msft and Dale 

 

Questions:

1. No "bu1", "bu2", "bu3" in the model. So I can't create a visual with them.

The requirements are each Region such as India will have its own Subsidiary which in my example are Mumbai and Delhi.



2. How to define these terms? There are PCE and FTPE. For example: Turnover.

Company defined Employee Turnover as follows

No of Full-Time Employees (FTSE ) + No of Permanents Contract Employees (PCE) for 1st Half 2017= 99

No of Full-Time Employees (FTSE ) + No of Permanents Contract Employees (PCE) for 2nd Half 2017= 108

In 1st Half 2017, No of Hirers = 0
In 2nd Half 2017, No of Hirers = 0


In 1st Half 2017, No of Hirers = 2
In 2nd Half 2017, no of leavers = 12,


Employee Turnover is computed as for 1st Half 2017 = [(0 /((99 + 99)/2)]*100 = 0
Employee Turnover is computed as for 2nd Half 2017 = [(2 /((99 + 108)/2)]*100 =0.0193 ~ 0.02
I guess, DAX can be used for this.








Q: Could you please show how you change the relationships?
 Is it possible for samples Visuals for BUs and Employee Turnover?

Thanks!

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
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

    Thanks v-jiascu-msft and Dale for all your help ...

     

    I am able to generate reports via Power BI ..

    Thanks again!